• TECHBABU (2/22/2011)


    Is this domain user part of SYSADMIN or Local Administrator group of mirror server ?

    Verify if this user is part of WITNESS\PRINCIPAL not added to Mirror

    Cheers

    Sat

    It is not a permission issue at all.It occurs intermittently.I think I figured it out.

    At times,my application server could not connect to my principal server due to loss of network or choked network.So from its cache it used the name of mirror server to connect.But as mirror server is in no-recovery mode,it is not accessible and hence the login failure

    I also figured out that the application server has nothing to do with which is principal or mirror at that moment.it will try to connect to both servers and will make a connection wherever it is successful.