Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

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

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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