User Account Question 1

[bikerboy718]

I have been tasked with trying to move sql server user accounts from a sql server 2000 instance to a sql server 2008 R2 box.

I have about 200 databases each with unique user ID's. I know that the security information is stored in the master DB. Is it possible for me to extract the user name and passwords? I do not believe that I can restore the master db from the sql server 2000 to the sql server 2008 R2. Is this correct? What are the different ways that I may be able to accomplish moving the user id's and passwords?

Any help would be greatly appreciated.

With Great Power Comes Great Responsibility!!!

Michael

 

[SQLBill]

Yes. All you need to do is run the following command, take the results and run it on the new server.

sp_help_revlogin

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SQLBill]

Ooops. Left one thing out...review the logins and remove any that should not be run on the new server. For example, SA and Builtin\Administrator logins should not be run on the new server.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[bikerboy718]

Thanks for your response Bill. I am going to look into using this method.

With Great Power Comes Great Responsibility!!!

Michael