Post reply

SQL Users Ids - Mutiple Servers

  • October 11, 2006 at 9:21 am

    #115881

    I have a Production DB Server and a Development DB Server. The development server as so acks as a backup Prod server. What can I do and how to keep the ids the same either through a export/import process or something else? Thanks

  • October 11, 2006 at 10:15 am

    #665264

    ids can be transfered between machines using the following script

    http://support.microsoft.com/kb/246133

     

    Also if using Log Shipping or Mirroring for your backups, it saves lots of security issues having all of the SQL services running under a single Windows ID. 

     

    Good luck

    Eric

  • October 12, 2006 at 10:15 am

    #665540

    I have tried that script (http://support.microsoft.com/kb/246133) in SQL2005, but I was getting the below error:

    Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12

    Invalid object name 'master..sysxlogins'.

    .

  • October 12, 2006 at 12:28 pm

    #665582

    Does this type of process require them to be on a domain? Can it be just in a workgroup?

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy