Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rickb
Starting Member
2 Posts |
 Posted - 2006-06-24 : 23:34:31
|
| I am having trouble getting data moved from SQL 2000 to SQL 2005 standard.1. Is there a “server copy” in 2005 like in 2000 to copy all objects between servers?2. Since I have not found the same server copy wizard in 2005 I have been trying to use the copy database wizard but I am still having trouble. Trying one database at a time and only copying the logins associated with this database. It will copy the db and the login but I am getting this error;OnError,HOST2,NT AUTHORITY\SYSTEM,HOST1_HOST2_Transfer Objects Task,{36D4B9AE-DF3F-44BA-82B2-13B7FA680EAE},{0E8500FF-505B-4FCD-9ABD-C4989DAB31F0},6/24/2006 8:10:06 PM,6/24/2006 8:10:06 PM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'ASMSWebAdmin', @name_in_db = N'ASMSWebAdmin'" failed with the following error: "'ASMSWebAdmin' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.I can go back and set the user as the owner but I still have to reset the password because it is not correct when I test it. This is happening on any of the databases that I tried to copy over. I am using the “sa” user to login on both machines so I should have permission to do this. Any one out there have any suggestions?3. How come it looks to be using NT AUTHORITY instead of the sa account?ThanksRick |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-25 : 00:31:33
|
| Would taking a Backup from the SQL2000 server and restoring it on SQL2005 be any good to you?Kristen |
 |
|
|
rickb
Starting Member
2 Posts |
Posted - 2006-06-25 : 01:39:35
|
| Only if it will copy the logins for the databases, there is a login/owner for each db and there are about 100 of them. That is why I was looking for the DTS package to copy all the db's at one time unless there is another way to do this?ThanksRick |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
|
|
Trouble copying db's from 2000 to 2005