I am trying to copy a database from 2000 to 2005 using the copy database wizard. I am a sys admin on both the source and destination server and am using the windows auth method and sql management object method. I am not copying any database objects.
Following is the report: Any suggestions?
Performing operation...
- Add log for package (Success)
- Add task for transferring database objects (Success)
- Create package (Error)
Messages
No description found (Copy Database Wizard)
- Start SQL Server Agent Job (Stopped)
- Execute SQL Server Agent Job (Stopped)
Rookie,
did you install SQL05 to anything other than C: ?
Is your SQL05 running on Win03r2 ? Is the machine a AD DC ?
See:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=185560&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=182988&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=127672&SiteID=1
MikeC
It is installed on c: I am using the client machine.
Windows 2003 enterprise edition 64 bit
It's not a ad dc machine.
cheers
|||Rookie,
Thanks, for the info. So, all of SQL05 (std, ent or dev?) is installed on C:? Default location? ("C:\Program Files\Microsoft SQL Server" and "C:\Program Files\Microsoft Visual Studio 8", etc)
Like you, I would really like to know the root cause of this problem. I poked around for a while and did not find anything that pointed me in the right direction to fix it - other than uninstalling/reinstalling VS and SQL with common components on C: rather than on E:. I did a complete format/install twice that produced the same failure to save a package - fresh installs of MS products.
Did you install a full version of Visual Studio 2005 pro on the same machine as SQL Server 2005?
Installing VS05 is the step that broke saving a package for me (worked before, broke after VS05 install). Maybe the 64bit C++ tools have something to do with this. I installed these in VS.
You might try opening a command prompt on the "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727" directory and running "ngen executeQueuedItems" then "ngen update" to check that the pre-JIT queue is clear and that there are no broken dependencies.
I called M$ support on this one and they seemed to think that it was just a bad setup... I did not want to waste a support call on it... Yet...
MikeC
Full text of the errors:
Error from create SSIS package (save to server):
===================================
No description found (Microsoft Visual Studio)
Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword) at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package) at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)
===================================
Error from copy db wizard:
===================================
No description found (Copy Database Wizard)
Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String
serverUserName, String serverPassword) at Microsoft.SqlServer.Management.CopyDatabaseWizard.PackageCreator.SavePackage()
===================================
|||Yes everything is installed on the same default location c:
yes visual studio 2005 is installed on the same machine as sql server 2005
ngen executeQueuedItems works fine but ngen update gave the following recurring error:
Failed to load dependency Microsoft.ReportingServices.Modeling of assembly Micro
soft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, Publi
cKeyToken=89845dcd8080cc91 because of the following error : The system cannot fi
nd the file specified. (Exception from HRESULT: 0x80070002)
should i try re installing both sql server and vs.
thanks for all the help
|||RookieDBA,
Ok, so SQL05 installed with VS05 is one commonality to the problem. I'm not sure why installing to default locations on C: would cause this problem for you, as I get this "save package error" only when I tried to install to a non-default E: volume. It would be nice for someone at Microsoft to look into this error and AT LEAST give us a better understanding of what the underlying problem is.
Ok, "ngen executeQueuedItems" completed - meaning all queued items from the install were completed, that's good.
The "cannot file file" for Microsoft.ReportingServices.Modeling dependancy of Microsoft.ReportingServices.QueryDesigners means that ngen cannot find a reference to the Microsoft.ReportingServices.Modeling.dll file for the Microsoft.ReportingServices.QueryDesigners.dll file that was installed into the Global Assembly Cache (GAC).
I'm not sure why the RS installation puts only some of the RS "private" assemblies into the GAC creating these reference errors. Again Microsoft should answer this question.
If you would like to remove this ngen error (and likely speed RS loading/designing), add the Microsoft.ReportingServices.modeling.dll file to the GAC (i.e. drag the file to the C:\Windows\Assembly folder - use two explorer windows).
But, you will find that a whole bunch of RS dlls will need to be added to the GAC (generally it won't hurt to do this) to resolve all dll dependency errors as reported by ngen.
Reinstalling, both SQL05 and VS05 to C: will likely fix the package saving problem.
MikeC
No comments:
Post a Comment