Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

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

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
add comment

http://technet.microsoft.com/en-us/library/cc917706.aspx 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
add comment

Your Answer

 
discard

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.