Hi,

I have an application which requires a connection to DB running on SQL
server 2005. The client OS is running Windows 2003 SP1. When trying to
configure the connection, I get the following error:

Connection Failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect())
Connection failed:
SQLState:'08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCIP/IP Sockets]SQL Server does not
exist or access denied.

Everything was working fine on this server, however after a regularly
scheduled reboot this stopped working and connection to the database is
broken....

I have tried everything, nothing seem to be working. The SQL server is
working fine, I am able to connect to the server from other clients without
any issues, so I know it has to be something on this Win2k3 server, but can't
figure out what. I even installed the SQL Server 2005 client to see if that
will help no luck. I suspect a ODBC driver issue but not sure.

Any help in this matter would be greatly appreciated.

Rocky (Rocky (AT) discussions (DOT) microsoft.com) writes:
The error message means that you are not able to reach SQL Server for
whatever reason.

Here are some links to try:
http://blogs.msdn.com/b/sql_protocol...22/483684.aspx
http://support.microsoft.com/default...N-US%3bq328306


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx