2

I have configured log shipping in my primary serverA and secondary serverB.

Everything works fine until I bring the standby database online.

Users are not able to login to the secondary serverB database (which is on the secondary server, which is brought online)

Can anyone help me on this?

3
  • What is the error you are getting,while users are logging in Commented Feb 26, 2016 at 9:14
  • logshipping is not server level,may be you gave some one has access primary DB but not secondary ? Commented Feb 26, 2016 at 9:15
  • 1
    That is classic case of orphaned users. In Loshipping you restore database which only moves users and this causes orphaned users on secondary databases. Run sp_change_users_login @action=report to list all orphaned users of a database
    – Shanky
    Commented Feb 26, 2016 at 9:30

1 Answer 1

5

LogShipping does not replicate server level objects such as logins, so your user will be unable to log in to the secondary server when you switch roles.

You can migrate existing logins using the sp_help_revlogin stored procedure, keeping SIDs and passwords for SQL authenticated logins.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.