Home Forums SQL Server 2008 SQL Server 2008 Administration Connection pooling troubleshooting in SQL 2008, client unable to reuse a session with SPID... RE: Connection pooling troubleshooting in SQL 2008, client unable to reuse a session with SPID...

  • We've been consistently seeing Error 18056, Severity 20, state 29 about the "client" was unable to reuse the session being reset for connection pooling and it says to look for a previous process which may have caused it. There is usually NOTHING happening previous to this error. Sometimes there may be an informational message prior to the error, but it looks to be coincidental and not related. We have 1 process which runs 24x7 and some which run almost that much.

    Is there a way to find out who the "client" is?

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."