Solved

SQL 2008 Connection Failed when connecting through ODBC

Posted on 2010-08-16
9
806 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 1

Expert Comment

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

Author Comment

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

Expert Comment

by:lundnak
ID: 33450130
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 1

Author Comment

by:ITGhost
ID: 33450139
All three are enabled.
0
 
LVL 8

Expert Comment

by:Julianva
ID: 33452236
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
ID: 33453772
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
ID: 33453870
dhlotter
the backslash is quite right, mistake in my comment.

0
 
LVL 1

Author Closing Comment

by:ITGhost
ID: 33455316
Thanks for this answer.
0
 
LVL 2

Expert Comment

by:dhlotter
ID: 33461566
pleased we could help
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

726 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