0

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?

Improve this question

2 Answers 2

Reset to default
1

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

Improve this answer
1
  • 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. Commented May 1, 2010 at 17:27
1

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

Improve this answer
1
  • 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. Commented May 1, 2010 at 17:37

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.