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:
SQL Server Error: 10061
[Microsoft][ODBC SQL server Driver][TCP/IP Sockets] ConnectionOpen
SQL Server Error: 17
[Microsoft][ODBC SQL server Driver][TCP/IP Sockets] SQL Server does not exist or access denied.