copying logins and permissions

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

copying logins and permissions

Author

Topic

jamie
Aged Yak Warrior

542 Posts

Posted - 2006-10-26 : 09:22:49

hi,
has anybody else had this problem ?

I backup a database from serverA then restore to serverB.
but none of the users that have permissions on serverA exisit in serverB. - is there any way of taking the logins and permissions from one server / db to another ?

also, If I do create the users on serverB , when I restore the database from serverA to serverB the users do not automatically have permissions to the database. when I try to add the user I get the error, 'the user already exists' . The only way I can get around this problem is to delete the user from the database users and relink the permissions for that user in security / logins .

can anybody give me some tips of how to make all this abit easier / quicker ?

regards.
Jamie

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-10-26 : 09:34:15

create the logins on serverB ... use sp_change_users_login to remap users to logins.

Jay White