Post reply

Copy accounts to secondary log shipping server

  • March 11, 2011 at 9:08 am

    #248038

    We just implemented log shipping and use the secondary DB server for reporting. How can I add the existing users on the primary server to the secondary DB so they can access the database. Do i need to create a new account on the primary server, get the SID and create a new account on the secondary server with the same SID or can i migrate the existing accounts over to the secondary server? Help is greatly appreciated and thanks in advance!

  • March 11, 2011 at 9:31 am

    #1297732

    I figured it out.

  • May 26, 2011 at 2:00 pm

    #1330623

    Would you be able to let me know what you did to fix this?

    I have implemented log shipping and now they want me to add a new sql server account.

    I added the account to the primary.

    Then I used the sid from primary to create the account on the secondary master database.

    Problem is: The user account doesn't show up in the secondary databases.

    How do you add new accounts to the primary and get them to show up in the secondary?

    Thanks,

    Mark

  • May 26, 2011 at 4:09 pm

    #1330701

    Coozie has duplicated posted here but it is good forum etiquette to post your resolution to an issue to help others.

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

  • May 26, 2011 at 4:49 pm

    #1330714

    Its also a good idea to disable the login at the source (if possible) to prevent accidental access there

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

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