Just upgraded a vendor app from sql 2005 to sql 2008 r2 sp1 and are consistently getting Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 72, which had been reset for connection pooling. I have applied all patches and stil lcan't get rid of error. User's seeing timeouts (the box itself is doing little). ANyone found a way to overcome this error?
Software/Hardware used:
ASKED:
January 5, 2012 3:12 PM
UPDATED:
February 28, 2012 12:18 PM