copy of logins an users between servers 
Author Message
 copy of logins an users between servers
Hi!

Can anyone tell me how to copy logins and users for a
specific database on to another server



Tue, 20 Jul 2004 21:20:19 GMT
 copy of logins an users between servers

Fredrik,

Quote:
>>> Can anyone tell me how to copy logins and users for a
> specific database on to another server

The database users get transferred when you restore the backup of that
database .This is bcoz users are for database level but logins are for
server level.
To copy over the logins which are located in master..syslogins you can refer

http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP

After that if you face any problem with login-user mapping pls refer
"sp_change_users_login" in BooksOnLine.
Along the same lines you may find the foll.article helpful...

PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/support/kb/articles/Q168/0/01.ASP

Dinesh.


Quote:
> Hi!

> Can anyone tell me how to copy logins and users for a
> specific database on to another server



Tue, 20 Jul 2004 22:39:35 GMT
 copy of logins an users between servers
Refer to the following knowledge base article which will
explain the issuses and provides a sample script you can
use:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133

--Sue

On Fri, 1 Feb 2002 05:20:19 -0800, "Fredrik"

Quote:

>Hi!

>Can anyone tell me how to copy logins and users for a
>specific database on to another server



Tue, 20 Jul 2004 23:04:21 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Copying Users logins between Servers

2. COPYING USER LOGINS

3. How to copy LOGINS from server to server

4. Transferring logins/users/logins

5. Copy SQL Server Logins and Passwords

6. Copy logins from one server to another

7. Copy all sql logins and passwords to new server

8. Copying logins between servers

9. Copy SQL Server Logins and Passwords

10. Copy logins between servers

11. Copying logins & passwords to other Servers

12. Copying logins/passwords from one sql server to another


 
Powered by phpBB® Forum Software