We help IT Professionals succeed at work.

SQL 2008 express connection  errors 10061 and 17

Alan Duck
Alan Duck asked
on
387 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
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
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'
Alan DuckTechnical Director

Author

Commented:
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
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
Next to TCP/IP is NamedPipes enabled and running?

What happens on the client if you run:      telnet serverip 1433
Alan DuckTechnical Director

Author

Commented:
Running the above telnet serverip 1433 failed to connect
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
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.
Alan DuckTechnical Director

Author

Commented:
the error says it cannot open connection to the sql ip address on port 1433 failed to connect
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
It should indicate

dbserver
Alan DuckTechnical Director

Author

Commented:
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
Patrick BogersDatacenter platform engineer Lindows
CERTIFIED EXPERT

Commented:
Yes, and not being able to telnet tells you port 1433 is not available or prohibited.
Alan DuckTechnical Director

Author

Commented:
I shall run tests on the ports
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.