SQL Connection Failure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joga (c0ldandb1ue_at_h0tmai1_._c0m)
Date: 08/25/04

  • Next message: Rand Boyd [MSFT]: "RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." 
    Date: Wed, 25 Aug 2004 13:31:01 -0700

    Experiencing 2 different errors before being able to connect to the database.
    This happened 2 times, 7 days apart, and the problem was resolved by
    selecting OK thru the errors and allowing the program (Access) to connect.
    1st error occurs twice and the 2nd error, which is an Access Error occurs, 1
    time, then theres connectivity. The Access error is an error we recieve, when
    this connection error occurs. I have already checked our ODBC connections and
    everything is correct. No problem after that, but the false errors are
    annoying.

    SQL Server: Win Server2kSP4 with SQL Server 2000, MDAC 2.8
    Workstation: Win XP Pro SP1 running office XP Pro.

    1st error:
    Connection failed:
    SQLState '01000'
    SQL Sever Error: 2
    [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
    Connection failed:
    SQLState '08001'
    SQL Sever Error 17
    [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or
    access denied.

    Any heads up on why it does this? COuld it be a connectivity issue?
    Thank You.
    Joga 

    -- 
please replace 0 with o and 1 with l to email me directly. Thank You.
  • Next message: Rand Boyd [MSFT]: "RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

    Relevant Pages

    • VLC & Freebox
      ... i'have installed the vlc-devel in the port tree. ... VLC media player 0.8.6a Janus ... main access error: Connection to mafreebox.freebox.fr port 80 failed: Operation timed out ...
      (comp.unix.bsd.freebsd.misc)
    • Re: com.mysql.jdbc.UpdatableResultSet.updateBlob gives AbstractMethodError
      ... access error occurs or this method is called on a closed connection." ... Statement readstmt = con ...
      (comp.lang.java.databases)
    • Re: RDB limitations: from Jimmy Gavan
      ... Your DBI QUESTION: ... Bearing in mind no compiler to reference or even test my thoughts, ... The unique Id is used as a DB connection ... move SQLSTATE to MOST-SQLSTATE ...
      (comp.lang.cobol)
    • Re: SQL Server ODBC Database Reconnect questions
      ... The first two characters of SQLSTATE are an error categorization, ... characters indicates a connection error. ... indicates a connection failure during SQLEndTran. ...
      (microsoft.public.data.odbc)