Replicating User Accounts

Nix

Is it possible to the replicate SQL user accounts and settings to another server when using log shipping to replicate the databases and logs. I notice when I stop replication and try to bring up the replicated SQL databases in our DR site, I have to recreate the user accounts that were on the production database by hand and associate them with the replicated DB each time I start and then stop replication.

I assume SQL user accounts have SSID's or the SQL equivalent of that when the account is created that makes it unique to that SQL install but I would figure there must be a way to replicate that out to the DR SQL box where the DB's are being replicated to or is that just wishful thinking?

petey

You can use the sp_change_users_login stored procedure to recreate the logins. There are scripts you can find to automate this somewhat e.g. here and here.