SQL Disconnects Intermittenly During Day

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rod at MHC (RodatMHC_at_discussions.microsoft.com)
Date: 12/23/04

  • Next message: mageos: "Error selecting text from a SQL database" 
    Date: Thu, 23 Dec 2004 10:27:06 -0800

    I have two users who are being disconnected from the server intermitently
    during the day. We're running Access 2000 and Great Plains. It appears that
    the odbc connections are stepping on each other somehow.

    The error message is Connection Failed: Sqlstate 01000.
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect())
    Connection Failed.
    SQL State 08001
    Server Not Found.

    This has only started to happen after we upgraded to GP 8, Sql Server 2000
    and Windows Server 2003.

    Can anyone help?

  • Next message: mageos: "Error selecting text from a SQL database"

    Relevant Pages

    • SQL Error
      ... I've the same problem after i changed the OS client from ... Win98 to WinXP, now i also still investigate about it!! ... >Sql state '08001' ... >Now the situation is this that our sql server is ...
      (microsoft.public.sqlserver.clients)
    • Re: Client "Host not found"
      ... iSeries server. ... SQL STATE: 08S01 ... ERROR CODE: 0 ...
      (microsoft.public.sqlserver.jdbcdriver)
    • CryptoAPI function CryptAcquireContext failed
      ... on a machine with NT 4.0 SP6a: ... MSSQL Server logon. ... SQL State 42000 SQL ...
      (microsoft.public.sqlserver.msde)
    • Connecting to to Sql server through ODBC
      ... I am having problems accessing the sql server through ODBC. ... SQL State: 01000 ... The win 2003 server is not running Active directory. ...
      (microsoft.public.sqlserver.server)
    • Re: SQL Server 2000 Instance connectivity Issues
      ... Can you ping the server? ... Did you try using server name as ... SQL State: '01000' ... SQL Server Error: 6 ...
      (microsoft.public.sqlserver.connect)