Connection Failed when creating ODBC connection to SQL 2005

• aloi

  SSC Enthusiast

  Points: 125

  More actions

  May 5, 2009 at 7:37 pm

  #204420

  I have two computer.

  One computer has no problem connecting ODBC way to my SQL 2005 server.

  The other computer I am adding a System DSN, I am selecting the sql server driver, I typed in my name and selected my SQL 2005 server and clicked on "Next". I leave it at windows nt authentication and click on "Next" and then I get the following error message:

  Connection failed:

  SQLState: '01000'

  SQL Server Error: 233

  [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionWrite(GetOverLappedResult()).

  Connection failed:

  SQLState: '08S01'

  SQL Server Error: 4

  [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

  I checked my SQL 2005 server where tcp/ip and named pipes is enabled.

  Can someone please shed some light?

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  May 5, 2009 at 9:45 pm

  #989327

  You might want to try updating the mdac components. You can download the latest HERE.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot