June 19, 2003 at 10:05 am
Hello guys,
I'm running sql 2k on an NT box which is going away and we have to replace it with Win 2k Advanced Server.
I'm assigned the job of copying or moving a dozen databases to the new machine.
I used the Wizard in Enterprise Manger to copy the database to the new server. Connection was successful but I got the follwoing error.
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700
I was using the Windows Authentication credentials on the Source Machine and SQL Authentication to connect to the destination SQL Server.
The message I'm getting says pro completed with error.
Thanks for your help
June 19, 2003 at 10:18 am
Don't use the wizard. It's a piece of #@$%#%$#
http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp
http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
Steve Jones
June 25, 2003 at 9:37 am
Thanks Steve for the links, they are really valuable.
I have a question hope to get it answered. When I'm trying to copy the mdf and ldf files to my DATA directory in the destination server, I get an error message that says "Cannot copy ..._log: there has been a sharing violation.". There isn't any users connected to the database. Thanks for any hints.
June 25, 2003 at 9:41 am
Stop the SQL Server service. Should be ok then. But only during downtime!
Ritch
*I didn't do anything it just got complicated*
Edited by - Ritch on 06/25/2003 09:41:53 AM
"I didn't do anything it just got complicated" - M Edwards
June 25, 2003 at 10:40 am
Thanks Ritch...
June 26, 2003 at 7:10 am
Okay guys, I'm back to square one. I did the following:
sp_addlinkedserver 'myserver'
Now when I execute the script written by Rahul Sharma to copy the logins over to the new server,
http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
I'm getting error err msg: 18452 login failed for user 'null'. reason not trusted sql server connection.
I'm logged on as Administrator on both servers. The source machine is WinNT and the destination is Win2k both with sql 2k. Is there anything that I need to do to make this work? please help. If not how can I manually change the logins/passwords on the destination server. Thanks
June 26, 2003 at 7:24 am
Read one of the threads below, about transfering logins. May help you out.
Ritch
*I didn't do anything it just got complicated*
"I didn't do anything it just got complicated" - M Edwards
June 26, 2003 at 7:34 am
Ritch, I guess your intention was to provide a link, right? could you please do that. Thans
June 26, 2003 at 7:41 am
Els,
It's an active thread in administration titled 'Transfering Logins to a new server', posted by StefanJ.
It's a long link, so it may break.
Ritch
*I didn't do anything it just got complicated*
"I didn't do anything it just got complicated" - M Edwards
June 26, 2003 at 10:58 am
Thanks guys for all the help. This knowledge base by microsoft helped me transfer the logins.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133
I used the sp_help_revlogin procedure to fix the problem. Thanks alot
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply