Post reply

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

  • April 28, 2010 at 6:35 am

    #96802

    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?

  • April 28, 2010 at 7:28 am

    #1158899

    KEVIN KENNY (4/28/2010)

    Can SQL Replication be used to publish SQL Server 2000 system databases to another SQL Server 2000 server, i.e master, model, msdb?

    No

    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?

    If windows authentication ids ONLY use transfer logins task from DTS else use sp_help_revlogin which will maintain sids and passwords (google it)

    ---------------------------------------------------------------------

  • April 28, 2010 at 7:52 am

    #1158928

    George,

    Thanks for the swift response. I suspected this might be the case.

    Cheers

    Kevin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply