Solved

SQL 2008 Connection Failed when connecting through ODBC

Posted on 2010-08-16
9
802 Views
Last Modified: 2012-05-10
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.

I'm at a loss. This is a named instance, not listening on port 1433.  I can connect to the database in the management studio with no problem. Any help would be appreciated.
0
Comment
Question by:ITGhost
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 1

Expert Comment

by:Wiebren
Comment Utility
Have you tried turning off the firewall for minute to see if thats the issue ?
0
 
LVL 1

Author Comment

by:ITGhost
Comment Utility
I have turned off the Firewall, but tried immediately afterward.  This is on a single server, however.
0
 
LVL 7

Expert Comment

by:lundnak
Comment Utility
Please make sure that Shared Memory is turned on for the Client Protocols on your SQL Server.

1. Open SQL Server Configuration manager
2. Browse to SQL Native Client x.xx Configuration
3. Click on Client Protocols.

Are Shared Memory, TCP/IP, and Named Pipes enabled?
0
 
LVL 1

Author Comment

by:ITGhost
Comment Utility
All three are enabled.
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 8

Expert Comment

by:Julianva
Comment Utility
when you create your odbc in servername dialog do this

servername/instance,portnumber - eg testserver/testdb,3306


you must specify port number when you have changed from default. Use the tcp protocol seems like you using named pipes, because named pipes uses shared memory.PLEASE MAKE SURE YOU  ARE USING THE CORRECT INSTANCE NAME - common mistake when using named instances. look in services for correct instance name if not sure



0
 
LVL 2

Accepted Solution

by:
dhlotter earned 500 total points
Comment Utility
try connecting through odbc datasource by specifying your servername like this

servername\instancename   (note the backslash)

in the client configuration, make sure you have TCP/IP selected and that the server alias and server name are both the same as the format above. also have 'dynamically determine port' enabled.

this should do the trick.
0
 
LVL 8

Expert Comment

by:Julianva
Comment Utility
dhlotter
the backslash is quite right, mistake in my comment.

0
 
LVL 1

Author Closing Comment

by:ITGhost
Comment Utility
Thanks for this answer.
0
 
LVL 2

Expert Comment

by:dhlotter
Comment Utility
pleased we could help
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Script to find duplicates 16 19
t-sql splitting string column 5 24
t-sql splitting name column 5 22
Test a query 23 11
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now