SQL Error

Last Post 06 Apr 2009 12:58 AM by Chris20. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Chris20
New Member
New Member

--
06 Apr 2009 12:58 AM
Hi

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.
You are not authorized to post a reply.

Acceptable Use Policy