Replicating Logins

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FS - 11 Jul 2008 20:31 GMT

Hello,
I have a SQL 2005 server in production and a standby server off on a remote
site. I use log shipping to keep the databases on the standby server in sync.
I was wondering if there was a way to extract the logins from my production
server, and somehow synchronize them to my standby server, with the passwords
and all the user mappings retained? Any help is greatly appreciated.
Thanks,
FS

Reply to this Message

Jason Massie - 11 Jul 2008 21:38 GMT

Yes. Use these procedures to generate the logins.
http://support.microsoft.com/kb/918992

Signature

Jason Massie
http://statisticsio.com
http://twitter.com/statisticsio
http://feeds.feedburner.com/statisticsio

> Hello,
> I have a SQL 2005 server in production and a standby server off on a
[quoted text clipped - 8 lines]
> Thanks,
> FS

Reply to this Message

Denny Cherry - 11 Jul 2008 21:42 GMT

You can download and install sp_help_revlogin on your primary server
to extract the needed information. You can find more information
about it here http://support.microsoft.com/kb/918992.

Denny

>Hello,
>I have a SQL 2005 server in production and a standby server off on a remote
[quoted text clipped - 4 lines]
>Thanks,
>FS

Reply to this Message