Copy the Logins

Hi,
I have SQL Server 2000 in Machine 'Machine1'. SQL Server
name is 'SQL1'. In SQL1, some miscellaneous databases
and some logins are there.
In a new Machine, 'Machine2', I've installed the another
SQL Server 2000 and the sql server name is 'SQL2'.
I have taken the backup of miscellaneous databases from
SQL1 and restored it in SQL2.
Now what I want is, how to copy the user logins from
SQL1 to SQL2, because all the logins are stored in master
database in SQL1.
kindly help, plz.
Sathu Kutti.Hi,
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"Sathu Kutti" <anonymous@.discussions.microsoft.com> wrote in message
news:240bb01c45f48$62086d60$a301280a@.phx
.gbl...
> Hi,
> I have SQL Server 2000 in Machine 'Machine1'. SQL Server
> name is 'SQL1'. In SQL1, some miscellaneous databases
> and some logins are there.
> In a new Machine, 'Machine2', I've installed the another
> SQL Server 2000 and the sql server name is 'SQL2'.
> I have taken the backup of miscellaneous databases from
> SQL1 and restored it in SQL2.
> Now what I want is, how to copy the user logins from
> SQL1 to SQL2, because all the logins are stored in master
> database in SQL1.
> kindly help, plz.
>
> Sathu Kutti.