none
even after fixing orphand user. loging is failing ?

    Question

  • after migration orphaned users were fixed but when failover happens secondary to primary login failed  then it is found as orphaned user .it is fixed and failover happen to primary again it is found as orphaned user .

    Please could you share permanent solution.why it is happening

    what are the steps to resolve this problem ?

    Thanks,

    Vijay

    Tuesday, March 11, 2014 3:17 AM

Answers

  • Hi

    the issue is due to the login's SID being different on your Primary and DR instance. You can identify the SID being used on each server by using the below query.

    SELECT name,sid 
    FROM master.sys.server_principals

    You will need to recreate login on the DR instance using the exact SID details from the primary server e.g.

    CREATE LOGIN mylogin WITH PASSWORD=N'mypassword', DEFAULT_DATABASE=[master], SID=0x0..

     

    • Marked as answer by vijay_1234 Tuesday, March 11, 2014 4:18 AM
    Tuesday, March 11, 2014 4:08 AM