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?

Improve this question
3
  • What is the error you are getting,while users are logging in
    – TheGameiswar
    Feb 26, 2016 at 9:14
  • logshipping is not server level,may be you gave some one has access primary DB but not secondary ?
    – TheGameiswar
    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
    Feb 26, 2016 at 9:30

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

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

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