We have high safety with automatic failover setup in our Sql Server 2008 R2 environment, and automatic failover is functioning without any issues. All the applications are also working as expected when the databases are failed over to Mirror server.
But i am seeing bunch of these error messages in SQL error log on the Current Mirror server(which was principal server before the failover). Can some one suggest is this a normal behavior or not?
Login failed for user 'XXXXXX'. Reason: Failed to open the explicitly specified database
Error: 18456, Severity: 14, State: 38.[highlight=#ffff11][/highlight]
Thanks in advance.