x

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

Kev
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

Blackhawk-17
11.9k 28 31 36

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x473
x343
x305

asked: Apr 28, 2010 at 09:28 AM

Seen: 3327 times

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