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?

2 Answers 2

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

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.
    – Kev
    May 1, 2010 at 17:27
1

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

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.
    – Kev
    May 1, 2010 at 17:37

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .