Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2008 ODBC Error 1

Status
Not open for further replies.

sleapz

IS-IT--Management
Jun 1, 2010
20
US
I'm new to SQL, so forgive me if this issue is noobish.

The problem I'm having, after after installing SQL Express 2008 is setting up the ODBC info. Using the System DSN tab I choose SQL Server, fill in all the applicable info, and when I hit "Next" after the authentication method is set I get the following:

Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

The SQL server that I'm trying to connect to is the same server that I'm setting this up on (app that requires SQL is on the same box -- didn't want to use a production SQL box).
Any help will be appreciated.
Thanks
 
I would suggest:

First, make sure the TCP/IP is enabled for your SQL instance. To do this, Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager. Expand SQL Server Network Configuration. Click on "Protocols for SQLExpress". On the right side of the screen, enable TCP/IP (if it's not already enabled).

Next, make sure you are using the TCP/IP protocol for your ODBC connection. To do this, there should be a button in the configuration wizard for "Client Configuration". Make sure TCP/IP is selected.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Thanks, the TCP/IP protocol was disabled, I also went in and unchecked the dynamic port assignment box and set the port.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top