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 |
|
jmcelvoy
Starting Member
2 Posts |
 Posted - 2009-06-05 : 09:37:28
|
| I need to move SQL from an old physical box running SQL 2000 to a new VM running SQL 2005. I Detached all the DB’s and copied the files to the new server and reattached the DB’s successfully. However, a couple of the DB’s weren’t working. The event viewer gave a Login Failure(Event ID 18456) for 3 users. Those 3 users were setup on the old SQL box a long time ago(before I was here) and I’m not sure what their passwords are. I found that there is a way to copy all the logins and their security settings from the old to the new server, but it’s all Greek to me. I’m not sure how to run the script and then how to output the results to run on the new server. Can anyone decipher this for me? Here are the 2 sites I found.http://www.databasejournal.com/features/mssql/article.php/2228611/Migrating-Logins-from-One-SQL-Server-to-Another.htmhttp://support.microsoft.com/default.aspx?scid=kb;en-us;246133I'm assuming I have to run something on the old server first, output that file to whatever and then run the output file on the new server. Not sure about any of this. |
|
|
jmcelvoy
Starting Member
2 Posts |
Posted - 2009-06-05 : 13:41:42
|
| Is this the right place to post this? |
 |
|
|
|
|
|
Migrating from SQL2000 to SQL2005