Need your help! We are receiving the below errors more frequently now. When ever we get this error, application gets timeout errors of Server not responding (System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding).
Here is the configuration of Production server :
Window server 2008 R2 Enterprise X64 bit; RAM:32 GB; Processors: 2 ( 16 Core each);
SQL Server : SQL Server 2008 R2 Enterprise CU4; Memory 1GB-29GB (max); MDOP=1 (OLTP Server);
I am getting this below error almost every day and it causing failure in the application.
2012-02-29 09:00:52.350 Logon Login failed for user 'XXX'. Reason: Failed to open the database configured in the login object while revalidating the login on the connection. [CLIENT: IP]
2012-02-29 09:00:52.350 spid74 Error: 18056, Severity: 20, State: 46.
2012-02-29 09:00:52.350 spid74 The client was unable to reuse a session with SPID 74, which had been reset for connection pooling. The failure ID is 46. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error.
I have researched on the Error a lot, did not find any particular solutions to it. I have found this link where this has been reported as bug to Microsoft, but no resolutions were posted.
So is this bug fixed or not ? Can you guys please help me to find the solution. do I need make any changes to setting in SQL Server.
Please help me!!!!