I have successfully moved a database from 2000 to 2008R2. Everything works, HOWEVER, there was ONE SQL user in the 2000 server that I did not move. The user still exists in the DB on the 2008R2 server, presumably now orphaned.
What I need to do is move the user from 2000 to 2008, including the DB password. Then I think what I have to do is delete the orphaned user in the 2008R2 database that moved, and re-add the moved database user and assign appropriate permissions. Am I wrong here?
I've tried running the Microsoft script for moving SQL users from SQL 2000 to 2005, and have been unsucessful (http://support.microsoft.com/kb/246133/
). After I paste the attached text from OPTION 2 to a file with an .SQL extension, the script runs and errors out with:
Msg 208, Level 16, State 1, Procedure sp_help_revlogin_2000_to_2
005, Line 19
Invalid object name 'master.dbo.sysxlogins'.
I have tried running it on the SQL 2000 server, on a SQL 2005 server connecting to the SQL 2000 server from the management console, and from the SQL 2008 server, and I keep getting the error listed above.
I do not need to move ALL users, I only need to move ONE particular user.
Can anyone help with this?