none
client was unable to reuse a session

    Question

  • Hello All,

    We are receiving the follwoign error in the production server, can any one provide any suggestions for this kind of error

    The client was unable to reuse a session with SPID 71, 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.

    Tuesday, April 20, 2010 11:52 AM

All replies

  • http://support.microsoft.com/kb/937745

     

    hth

    Vinay


    http://rdbmsexperts.com/Blogs/
    http://vinay-thakur.spaces.live.com/blog/


    Vinay Thakur http://rdbmsexperts.com/Blogs http://vinay-thakur.spaces.live.com/ http://twitter.com/ThakurVinay
    Tuesday, April 20, 2010 12:09 PM
  • Hi Vinay,

    The link that u sent is for Sql Server 2005 only while we are facing this problem with Sql Server 2008 as well.

    Pls help.


    Apps Dev
    Tuesday, April 20, 2010 12:16 PM
  • Pokiri1212,

     You can control connection pooling behavior by using the connection string options set for your ADO.NET data provider. For example, connection string options can define the following settings for the DataDirect Connect for .NET data providers:

    Number of connection pools (Max Number of Pools)

    Maximum connection pool size (Max Pool Size)

    Minimum number of connections in a connection pool (Min Pool Size)

    Number of seconds to keep connections in a connection pool (Connection Lifetime)

     

    Tuesday, April 20, 2010 12:31 PM
  • Thanks you vinay & Sufian for the reply. The link which u provided says apply the hotfix which has SP2 , but we already have SP3 on the server, so is this hotfix included in the SP3?
    Tuesday, April 20, 2010 12:42 PM
  • Yes SP2 is included in SP3.
    Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.
    Tuesday, April 20, 2010 12:55 PM