Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 ODBC Connection Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 1:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 9, 2013 2:45 PM
Points: 24, Visits: 144
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.
Post #1424237
Posted Wednesday, February 27, 2013 6:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 9, 2013 2:45 PM
Points: 24, Visits: 144
I resolved this by changing the default database to master in 2008. This was not the case for me and my systems in 2005.
Post #1424483
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse