August 17, 2009 at 11:56 am
We are finally upgrading our SQL 2K server to SQL sK5. I need to migrate all of my security (logins, DB access, etc...) from the old server to the new one.
Can anyone suggest some scripts and the process of doing this?
Many thanks in advance.
August 18, 2009 at 12:53 pm
when we did it we created all the logins manually and then ran sp_change_users_login after we restored the databases
August 19, 2009 at 6:26 am
There are scripts you can find to move your users. You can also use the copy database function and check to also copy users. We have done both successfully during our upgrades. Here would be a good place to start: http://support.microsoft.com/kb/246133
Mike
“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey
___________________________________________________________________
August 19, 2009 at 6:30 am
Thanks all, I found the script that works, it is from MS and is called: sp_help_revlogins and can be found at: http://support.microsoft.com/kb/918992
This script really worked nicely. Thanks to all for the replies.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply