Solved

SQL 2008 express connection  errors 10061 and 17

Posted on 2014-01-13
11
302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 22

Expert Comment

by:Patrick Bogers
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 22

Expert Comment

by:Patrick Bogers
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
 
LVL 22

Expert Comment

by:Patrick Bogers
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 22

Expert Comment

by:Patrick Bogers
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 22

Expert Comment

by:Patrick Bogers
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Query Task 11 43
Can I skip a node in XML? 9 31
user database (login sql or login windows) 3 20
Find special characters using tSQL 6 15
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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

740 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