Sql server 2008 connectivity issue

Question

0.00/5 (No votes)

See more:

Hi

We are having web application connecting to sql server, we are having unstable connection to server , Some times we are able to connect and some times we get below error message for port 1051

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)"

can you please suggest

Thanks

What I have tried:

we tried enabling disabling firewall, adding exception for port in antivirus but no luck. Is there any other settings or installation issue

Posted 13-Feb-16 2:24am

techsandi

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2016-02-13T04:45:00

An intermittent problem like that is usually either a bad network connection between the client (your web server) and the SQL server

OR

You've exhausted the connection pool on the client or a limit on the SQL server, possibly because you're not closing connections after you're done with them.

OR

You've got a performance problem with the SQL Server and it can't get around to responding to new connections in time.

From what you've posted, it's impossible to give you a specific answer as to what's wrong. This is going to take more troubleshooting from you.

What I can tell you is that this kind of problem never had a chance of being an antivirus or firewall problem.

johnwalker10 · Answer 2 · 2016-02-14T17:55:00

Solution 2

Go to All Programs >> Microsoft SQL Server >> Client Network Utility >> changed the protocol TCP/IP to 1433 or setup an odbc connection

Posted 14-Feb-16 17:55pm

johnwalker10

v2