moving logins & users

Hi ,
I need to move the logins & users from one SQL 2000
server to another SQL 2000 server , how shld i do that ?
and what are the tables do these logins & users resides
in ?
sysusers in the msdb db & sysxlogins in the master db ?
thks & rdgs
Hi,
Logins -- Will be residing in SYSXLOGINS table of Master database.
Users - Will be residing in each database inside SYSUSERS table. Users
inside this table will have prev. to access the database, apart from users
fall in SYSADMIN fixed role.
How to transfer syslogins between servers.
http://www.databasejournal.com/featu...le.php/2228611
Transferring users:-
Users will be automatically transferred once you restore the databases into
the destination server. So no need to transfer manually for
each databases.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:018801c48406$e6410eb0$a301280a@.phx.gbl...
> Hi ,
> I need to move the logins & users from one SQL 2000
> server to another SQL 2000 server , how shld i do that ?
> and what are the tables do these logins & users resides
> in ?
> sysusers in the msdb db & sysxlogins in the master db ?
> thks & rdgs
|||Hi Hari ,
thks for the links it's very useful
for the sysusers in each databases if i do not want to
do a restore for some reasons (i.e i do not want the same
databses in the new server) , this will mean that i might
as well re-create all the users as the "old users" will be
pointing to the old databases ?
rdgs

>--Original Message--
>Hi,
>Logins -- Will be residing in SYSXLOGINS table of Master
database.
>Users - Will be residing in each database inside SYSUSERS
table. Users
>inside this table will have prev. to access the database,
apart from users
>fall in SYSADMIN fixed role.
>
>How to transfer syslogins between servers.
>http://www.databasejournal.com/featu...l/article.php/
2228611
>Transferring users:-
>Users will be automatically transferred once you restore
the databases into
>the destination server. So no need to transfer manually
for
>each databases.
>Thanks
>Hari
>MCDBA
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:018801c48406$e6410eb0$a301280a@.phx.gbl...
db ?
>
>.
>
|||Hi,
Easy way will be generate the SQL Script for the user from each of the
databases in the source server and execute it in destination server.
1. In enterprise manager .. Select the database
2. Right click above the database and select "Generate SQL script
3. Go to "OPTIONS" Tab
4. Select the "Script database users and roles"
5. Go back to general tab and click Preview button
6. Click copy button and paste in the query analyzer window of destination
server.
7. Select the appropriate database and execute the script
Do the same for all databases.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:01d301c4840d$d4c4b900$a301280a@.phx.gbl...[vbcol=seagreen]
> Hi Hari ,
> thks for the links it's very useful
> for the sysusers in each databases if i do not want to
> do a restore for some reasons (i.e i do not want the same
> databses in the new server) , this will mean that i might
> as well re-create all the users as the "old users" will be
> pointing to the old databases ?
> rdgs
> database.
> table. Users
> apart from users
> 2228611
> the databases into
> for
> message
> db ?
|||thks Hari
>--Original Message--
>Hi,
>Easy way will be generate the SQL Script for the user
from each of the
>databases in the source server and execute it in
destination server.
>1. In enterprise manager .. Select the database
>2. Right click above the database and select "Generate
SQL script
>3. Go to "OPTIONS" Tab
>4. Select the "Script database users and roles"
>5. Go back to general tab and click Preview button
>6. Click copy button and paste in the query analyzer
window of destination
>server.
>7. Select the appropriate database and execute the script
>Do the same for all databases.
>Thanks
>Hari
>MCDBA
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:01d301c4840d$d4c4b900$a301280a@.phx.gbl...
to[vbcol=seagreen]
same[vbcol=seagreen]
might[vbcol=seagreen]
be[vbcol=seagreen]
Master[vbcol=seagreen]
SYSUSERS[vbcol=seagreen]
database,[vbcol=seagreen]
>http://www.databasejournal.com/featu...l/article.php/
restore[vbcol=seagreen]
in[vbcol=seagreen]
that ?[vbcol=seagreen]
resides
>
>.
>