Login failed for user 'XXX' on the mirrored sql server
Posted
by hp17
on Server Fault
See other posts from Server Fault
or by hp17
Published on 2010-05-16T02:31:33Z
Indexed on
2010/05/16
2:40 UTC
Read the original article
Hit count: 264
Hello,
We have 4 web servers that host our asp.net (3.5) application. Randomly, we get error messages like :
1) "Login failed for user 'userid'" 2) "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
we are running sql2005 and have a principle and a mirror db (sync). When these exceptions are thrown, I look at the SQL error logs on the mirrored db and noticed the failed login messages in there. The principle db is running fine and the other web apps are working great. this will happen for maybe 10 min, then the app pool recycles and it starts hitting the principle db again.
Is there a configuration I have incorrect? my theory is that our principle db is forwarding the request to the mirror, but that should never happen.
any help??
© Server Fault or respective owner