-2147467259 connection error

• Dan Chadwick-223229

  SSC Enthusiast

  Points: 171

  More actions

  April 19, 2005 at 12:41 pm

  #185726

  I am experiencing periodic issues connecting over the network with this error:

  The folowing error occured when connecting to the database:

  Error -2147467259 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

  Error -2147467259 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen [Connect(]).

  After a reboot of the client workstation, a connection is re-established. Is this a problem with DNS/WINS or a dropped connection to SQL? There are no other DNS/WINS issues at all currently, but I did notice that when the error was appearing a ping to the server displayed the server only, not the FQDN. The FQDN is specified in Sytem DSN in the ODBC connection.

• Farrell Keough

  SSCoach

  Points: 17414

  More actions

  April 22, 2005 at 9:50 pm

  #554473

  Suggestions I found were make sure SQL Agent is running and check your timeout; you may need to increase the length of timeout...

  Good hunting...

  I wasn't born stupid - I had to study.