Groups | Blog | Home
all groups > sql server replication > august 2003 >

sql server replication : Users



Whitney
8/13/2003 7:48:21 AM
If I'm replicating a server with 4 instances on this
server. What's the best way to move the users with it,
Narayana Vyas Kondreddi
8/13/2003 5:29:35 PM
How are you moving the database? If you are using backup/restore, then the
database will retain all the users, but you need to make sure there are
matching logins in the master database of the target server. Otherwise,
these users will be orphaned. You could use sp_change_users_login to
associate users with their corresponding logins. For more information see:
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


[quoted text, click to view]
If I'm replicating a server with 4 instances on this
server. What's the best way to move the users with it,
without deleting and recreating them?

AddThis Social Bookmark Button