Hello,

I have two SQL servers SQLA (Principal) and SQLB(Mirror). (SQL 2012 Standard on Win2K12R2).

During fail over from SQLA (Principal) -> SQLB(Mirror) occurs, the application is able to access the mirror copy and runs fine. Strangely in the Principal server every second there is the following eventid,

2015-07-28 16:29:00.17 Logon       Error: 18456, Severity: 14, State: 38.
2015-07-28 16:29:00.17 Logon       Login failed for user 'Domain\Account'. Reason: Failed to open the explicitly specified database 'DB_name'. [CLIENT: X.X.X.X]

Shouldn't after the fail over SQL should access the mirror server? any help appreciated!

Regards,

Harish Kumar

Make sure your user(Domain\Account) is having the same level of permissions on bot servers.

If it is a Active directory user make sure same permissions on both servers.

If it is SQL user make sure the SID is same on both servers.