muthyala_51 (7/16/2014)
Hi,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
Message
Error: 18456, Severity: 14, State: 38.[highlight=#ffff11][/highlight]
Thanks in advance.
This link describes state 38 pretty well, most likely you have orphaned logins on the mirror partner. Synchronise the logins across from the Primary to the mirror
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉