Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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:

share|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 covers synchronizing logins between publisher and subscriber

share|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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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