I am running SQL Server 2005 Standard SP3. Every couple of days the server will not allow users with SQL authentication to log in and the error log shows :
The client was unable to reuse a session with SPID 114, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
Error: 18056, Severity: 20, State: 23.
I found a hot fix which is supposed to fix this issue, but the hot fix is for SP2 and does not work for SP3.
Any help would greatly be appreciated.