Solved

SQL 2008 express connection  errors 10061 and 17

Posted on 2014-01-13
11
294 Views
Last Modified: 2014-01-25
over the weekend one of the SQL database become inaccessible

when we try to connect to the SQL instance we get the errors  below

it comes up with SQL state 01000
SQL server 10061
on the tcpip interface

also SQL State error 08001
SQL server error 17

if we test the SQL instance on the SQL server were it resides it works fine .

help would be appreciated
0
Comment
Question by:Alan Duck
  • 5
  • 5
11 Comments
 
LVL 12

Accepted Solution

by:
HugoHiasl earned 500 total points
ID: 39776525
The first thing I would check is if the protocols are still enabled in the server configuration.

Use the Sql Server Configuration Manager in "Configuration Tools" on the server and see if TCP/IP is enabled in the menu "SQL Server network Configuration" for the given instance.
0
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39776529
Hi

You have a connection issue, please check,

In SQL server configuration manager->  Is TCP/IP enabled?
Next, does the firewall have an exception for port 1433 to allow inbound connections
Last, On the server, right click server in SQL (properties) and check if there is a checkbox at 'allow remote connections'
0
 

Author Comment

by:Alan Duck
ID: 39776598
Have check the above
TCP/IP is enabled
have installed portn 1433 in to the firewall
and have checked that allow remote conections is ticked
0
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39776777
Next to TCP/IP is NamedPipes enabled and running?

What happens on the client if you run:      telnet serverip 1433
0
 

Author Comment

by:Alan Duck
ID: 39776894
Running the above telnet serverip 1433 failed to connect
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39776903
Then i assume you have some firewall or port issue somewhere.
I tested it against a running DB server and the screen went black (as expected)

Try to disable the firewall as a whole (and other firewalling software like Symantec Endpoint or MalwareButes)
If this doesnt resolve the issue i begin to think your SQL server is no longer listening to port 1433.
0
 

Author Comment

by:Alan Duck
ID: 39776907
the error says it cannot open connection to the sql ip address on port 1433 failed to connect
0
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39776918
It should indicate

dbserver
0
 

Author Comment

by:Alan Duck
ID: 39776947
has the Firewall is controlled by the domain this may take a little time but we can try this
if you run connection tests on the SQL server to the SQL datadabe they do work fine which suggest that the SQL  is working
0
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39776951
Yes, and not being able to telnet tells you port 1433 is not available or prohibited.
0
 

Author Comment

by:Alan Duck
ID: 39777053
I shall run tests on the ports
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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 setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now