Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Expand / Collapse
Author
Message
Posted Wednesday, March 5, 2008 6:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 9, 2013 2:41 AM
Points: 16, Visits: 110

I have installed sql2005 on a windows 2003 server. I can connect to the server using sql Server management studio and either windows or sql authentication .

However if I try to connect to the server via Query analyzer, odbc connection or my client software which uses ADO I get :

"[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied."

or
"Connection Failed
Sql State '01000'
sql server Error :233
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connectionopen(Connect().
Connection failed:
sqlstate'08001'
sqlserver error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied."


I have checked the firewall is switched off, I can ping the server and I can remote desktop to the server, port 1433 is open and it listens on this port.

I also have two other sql2005/windows2003 servers on the network and in same domain both of which connect via query anaylyzer and odbc connections.

If I can connect using sql Server management studio can anyone explain why I am failing to connect via odbc & ADO?
Post #464366
Posted Thursday, March 6, 2008 10:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 9, 2013 2:41 AM
Points: 16, Visits: 110
Whoooo hooo!! found an answer meself......

I searched on this msdn forum

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=129105&SiteID=1

and discovered that the Surface Area Configuration Manager? Remote connections are disabled by default. Look at the Database Engine -> Remote Connections option.

In my case I had to set local and remote connections to using both TCP/IP and Named pipes

Job done!!!

hope this helps someone
Post #464999
Posted Thursday, March 6, 2008 10:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:23 AM
Points: 2,153, Visits: 643
Hi,

Yep, this is the default behavior of SQL Server 2005, as you have already discovered.

Great result!

Thanks,
Phillip Cox
MCITP - DBAdmin
Post #465002
Posted Wednesday, March 4, 2009 11:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 18, 2010 10:18 AM
Points: 4, Visits: 6
THANK YOU!

Suddenly my Dev server was not allowing app connections.

Your solution was right ON!

/Rob



Kindest Regards,

Robert Dean Waibel, Jr
ilxresorts.com
Post #668514
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse