Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2008 ODBC Connection


SQL 2008 ODBC Connection

Author
Message
shusta
shusta
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 185
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.
shusta
shusta
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 185
I resolved this by changing the default database to master in 2008. This was not the case for me and my systems in 2005.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search