Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2003
    Location
    New Zealand
    Posts
    1

    Angry Unanswered: SQL Server Error: 10060-login sa-connection drops

    We have an issue on our network which drops the connection to SQL2000 and we have to login again using SQL login sa - most of the time it will reconnect immediately or we will get the error msg below.
    This is very annoying as some of our software needs to run 24hrs uninterrupted for testing purposes.
    I've tried named pipes and that doesn't stop the problem, and I'm using Server Login (SA) authentication model. I've also noticed that some of the Internet access is problematic (i.e. "can't find DSN for Google" type errors, "connection timed out" type errors.
    Does anybody know what and/or how to fix this ?
    It would be much appreciated !


    Connection failed:
    SQLState:'01000'
    SQL Server Error: 10060
    [Microsoft}[ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
    (PreLoginHandshake()).
    Connection failed:
    SQlState:'08001'
    SQL Server Error: 11
    [Microsoft}[ODBC SQL Server Driver][DBNETLIB]General Network error.
    Check your network documentation.

    -or-

    Connection failed:
    SQLState:'S1T00' - SQL Server Error : 0
    [Microsoft][ODBC SQL Server Driver]Timeout Expired
    Last edited by southpaw; 06-26-03 at 20:34.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •