SQL 2008 ODBC Error 1

[sleapz]

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

 

[gmmastros]

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

 

[sleapz]

Thanks, the TCP/IP protocol was disabled, I also went in and unchecked the dynamic port assignment box and set the port.