March 5, 2008 at 6:09 am
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?
March 6, 2008 at 10:32 am
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
March 6, 2008 at 10:41 am
Hi,
Yep, this is the default behavior of SQL Server 2005, as you have already discovered.
Great result!
Thanks,
Phillip Cox
MCITP - DBAdmin
March 4, 2009 at 11:14 am
THANK YOU!
Suddenly my Dev server was not allowing app connections.
Your solution was right ON!
/Rob
Robert Dean Waibel, Jr
ilxresorts.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply