SQL 2008 ODBC Connection

  • Hello,

    This is my first attempt at creating a ODBC connection from a workstation to a SQL 2008 server and I'm not having very good luck (SQL 2005 was not a problem.) I've been trolling the internet for some clues to what I might be missing and the few things that I did try were no good. I get what the error is telling me I just cant seem to find anything on the sever that is not enabled.

    - I checked TCP/IP

    - I added the user to SQL 2008 (Reader Only)

    Do I need a new Native client just for 2008?

    This was a full version from a vendor (Not MS) would there be other spots I might have to check that you normally wouldn't?

    This is the current error when I try to create an ODBC from my PC to the SQL 2008 server:

    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.

  • I resolved this by changing the default database to master in 2008. This was not the case for me and my systems in 2005.

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

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