February 26, 2013 at 1:34 pm
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.
February 27, 2013 at 6:09 am
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