Solved

SQL 2008 express connection  errors 10061 and 17

Posted on 2014-01-13
11
306 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 23

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
Technology Partners: 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!

 
LVL 23

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 23

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 23

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 23

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

739 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