Post reply

Connecting to SQL Server 2005 via ODBC DSN?

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply