Member_2_1242703
asked on
Copy user logins from one server to another
I have a server set up with SQL Server 2000 on machine A. I have the exact same setup on machine B.
Is there a way to copy the current login users from Machine A to Machine B?
TIA
Is there a way to copy the current login users from Machine A to Machine B?
TIA
You can use the SQL Server Import and Export Data utility. After selecting the data source and destination, in the "Specify Table Copy or Query" screen, select the 3rd option "Copy objects and data between SQL Server databases". In the next screen, unselect all check boxes and click on the Options button. In the Security options uncheck all options and check on "Copy SQL Server logins (Windows and SQL Server logins)".
Have you tried sp_sidmap -- downloadable from http://support.microsoft.com/default.aspx?scid=kb;en-us;298897
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
also it is good to have in Favorites just in case:
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/kb/246133/
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/kb/246133/
ASKER
I got all of the logins over, but they don't have access to the databases. Is there a way to add multiple user access (read, write, etc.) to certain databases?
Or do I have to go in and manually check each login and add them that way?
Or do I have to go in and manually check each login and add them that way?
The sp_sidmap -- downloadable from http://support.microsoft.com/default.aspx?scid=kb;en-us;298897 -- works againt the database logins to map them back to server logins.