up vote 0 down vote favorite
share [g+] share [fb]

Can SQL Replication be used to publish SQL Server 2000 system databases to another SQL Server 2000 server, i.e master, model, msdb?

If this is not possible, what is the correct strategy for keeping SQL Logins synchronised (more specifically their passwords) between a publishing server and a subscriber?

link|improve this question
85% accept rate
feedback

2 Answers

up vote 1 down vote accepted

You can't use replication on system databases, as they are inherently server- (and instance-) specific.

To copy logins, have a look here: http://support.microsoft.com/kb/246133

link|improve this answer
I saw that article, but it appears that both computers need to be domain members, which in my case they aren't. The subscription server is a new machine so I just restored the system databases then the databases to be replicated and all is good. – Kev May 1 '10 at 17:27
feedback
up vote 1 down vote

http://technet.microsoft.com/en-us/library/cc917706.aspx covers synchronizing logins between publisher and subscriber

link|improve this answer
I'll have a look at this but not sure if I'll be able to use due to the requirement for a shared folder. We're pretty heavily locked down. – Kev May 1 '10 at 17:37
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.