Connecting to SQL Server 2005 via ODBC DSN?

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  February 24, 2009 at 1:40 pm

  #128023

  I am trying to connect remotely to SQL 2005 via an ODBC DSN. I currently have SQL Server 2000 Client Tools installed on my laptop. I am getting the following error:

  Microsoft SQL Server Login

  Connection failed:

  SQLState: '01000'

  SQL Server Error: 10061

  [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).

  Connection failed:

  SQLState: '08001'

  SQL Server Error: 17

  [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

  How may I resolve this issue? Do I need to install the SQL Server 2005 Client Tools on my machine? (We are running SQL Server 2005 on Windows 2003.)

  Thanks, Kevin

• suzanne-892457

  SSCommitted

  Points: 1744

  More actions

  February 24, 2009 at 2:20 pm

  #949637

  I would definitely add the SQL2005 tools to your laptop. I believe you will then have the latest ODBC driver for SQL2005. Also, SQL2005, with a default install does not allow Remote Connections. These are at least 2 things you can try.