How to add new login to Log Shipping

  • I have implemented log shipping and now I've been asked to add a new sql server account.

    I added the account to the primary.

    Then I used the sid from primary to create the same 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

  • did you use sp_help_revlogin to transfer the new ID?

    what are the results when you run

    exec sp_helpuser

    and

    exec sp_change_users_login 'report'

    in the secondary database

    if you added the user in the primary database and have restored a log backup post that action on the secondary, it will be there.

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

  • george sibbald (5/26/2011)


    if you added the user in the primary database and have restored a log backup post that action on the secondary, it will be there.

    What he said. 😀

    Simply adding the login to both the source and destination SQL instance isnt enough. If a transaction log backup hasnt been taken, copied and restored the user wont be available at the destination

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

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