Can SQL Server 2000 replicate system databases and/or logins?

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?

asked Apr 28 '10 at 09:28 AM in Default

Kev
14 ● 4 ● 5 ● 6

(comments are locked)

1 answer:

You can use DTS, T-SQL scripting or manual processes.

One of the foremost articles on transferring logins is here.

answered Apr 28 '10 at 09:40 AM

Blackhawk-17
10.5k ● 23 ● 29 ● 34

Thanks for the response. This bit may be a stumbling block though: " If you are importing logins from an instance of SQL Server that is on a separate computer, your instance of SQL Server will must be running under a Domain Account to complete the task. " - sadly these are standalone machines.

Apr 28 '10 at 10:58 AM Kev

Keep reading the article and check out the sp_help_revlogin for transferring between SQL 2000 instances.

Apr 28 '10 at 12:28 PM Blackhawk-17

@blackhawk-17 - the sp_help_revlogin worked a treat. thanks.

Jun 23 '10 at 05:06 PM Kev

(comments are locked)