Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Server connection error: 10060, 17

2,745 views
Skip to first unread message

Rocky

unread,
Jun 24, 2010, 5:22:03 PM6/24/10
to
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.

Erland Sommarskog

unread,
Jun 24, 2010, 5:42:30 PM6/24/10
to
Rocky (Ro...@discussions.microsoft.com) writes:
> 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....

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_protocols/archive/2005/10/22/483684.aspx
http://support.microsoft.com/default.aspx?scid=KB%3bEN-US%3bq328306


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.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/prodinfo/previousversions/books.mspx

0 new messages