Login failed for user 'XXX' on the mirrored sql server
- by hp17
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??