How to copy SQL server logins from one server to another

Hi all...

I am in a process of copying all databases from a server to another. Both are running SQL Server 2000.

First of all, I tell you that I could not use "Copy Database Wizard" option because of a lot of problems with it. By using DTS didn't work either. Finally, the only solution was to backup the database first and then to restore it back to the new server. In such a case only database logins are restored, but not associated SQL server logins.

Is there a way to copy all SQL Server logins and link them to databases logins already created without the need of using sp_change_users_login procedure for each one?

Thanks a lot in advance

Jaime

I have found the solution by myself.

http://www.databasejournal.com/features/mssql/article.php/2228611

Thanks anyway

Jaime

|||

Hi,

you can script it...

You can use the enteprise manager(EM)

EM> in the console root> connect to the server>

> click on database>

> Right- click the database > click on all task

> Generate Sql scripts

in the generate sql script dialog

>Click on options

>Check Sql server logins

>click general tab and click preview

> run the scripts the other servers

hope it helps