Post reply

Intermittent connectivity problems

  • June 18, 2007 at 10:29 pm

    #196411

    Hello!
     
        We are getting intermittent '[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation' error from the client connected to SQL Server 2005 SP1 64-bit. I have noticed errors similar to one below in SQL Server log:'The client was unable to reuse a session with SPID 155, 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.'
        I was wondering if anyone has experienced similar connectivity issues and error above.
     
    Thanks,
    Igor

  • June 18, 2007 at 10:40 pm

    #713719

    I hope connection pooling is enabled. Can you try disabling that and see if the error occurs. Connection pooling might have been enabled for reasons so check before you disable the same.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 19, 2007 at 11:44 am

    #713920

    Sugesh,

    Client configuration hasn't changed. It was working fine for quite a while. i have found article suggesting that SQL Server might generate this error while having many concurrent connections:

     

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

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply