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?

more ▼

asked Apr 28, 2010 at 09:28 AM in Default

Kev gravatar image

14 6 6 6

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

One of the foremost articles on transferring logins is here.

more ▼

answered Apr 28, 2010 at 09:40 AM

Blackhawk-17 gravatar image

11.9k 28 31 37

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, 2010 at 10:58 AM Kev
Keep reading the article and check out the sp_help_revlogin for transferring between SQL 2000 instances.
Apr 28, 2010 at 12:28 PM Blackhawk-17
@blackhawk-17 - the sp_help_revlogin worked a treat. thanks.
Jun 23, 2010 at 05:06 PM Kev
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 28, 2010 at 09:28 AM

Seen: 4208 times

Last Updated: Apr 28, 2010 at 09:28 AM