Login Failure RRS feed

  • Question

  • There have been other similar posts, but this is my issue:  I have set up database mirroring with a witness, and failover works properly.  I have also installed the login id's and their original SID's onto the mirror server.  When I run a Reporting Services report against the primary database, it runs properly.  When I failover to the mirror server and run the report again, I get a "login failed for user" error.  As I have already said, the SQL login that the  Reporting Services report uses was installed on the mirror server with the original SID.  Any ideas as to what else might be wrong?
    Tuesday, January 16, 2007 9:14 PM

All replies

  • My first suggestion would be to check the permissions of the user who is attempting to log in.



    • Proposed as answer by XtendedLearner Wednesday, April 6, 2016 3:06 PM
    Thursday, January 18, 2007 4:23 PM
  • Can you check the SID on master and user databases similarity?

    Also specify a valid, available database in the connection string. To avoid the error when the user's default database is unavailable, log on as a user who can modify logins. Then, change the user's default database to a database that is currently available for a connection.

    Friday, January 26, 2007 5:48 PM