We just migrated our from sql 2005 to sql 2008R2. Occasionally we do see the following error message and timeouts in our application
"Date 4/13/2012 3:30:37 PM
Log SQL Server (Current - 4/13/2012 8:00:00 PM)
The client was unable to reuse a session with SPID 172, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
I did little research and this article "http://blogs.msdn.com/b/psssql/archive/2010/08/03/how-it-works-error-18056-the-client-was-unable-to-reuse-a-session-with-spid-which-had-been-reset-for-connection-pooling.aspx?wa=wsignin1.0&CommentPosted=true#commentmessage" seems to have something, but i couldn't find a solution. Has anyone faced this issue before? We are currently on sql2008R2 standard edition with SP1 +CU3.
P.S: I couldn't find a place for SQL 2008R2 questions , so i just posted here.