Click here to Skip to main content
15,908,172 members
Please Sign up or sign in to vote.
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

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.
 
Share this answer
 
Go to All Programs >> Microsoft SQL Server >> Client Network Utility >> changed the protocol TCP/IP to 1433 or setup an odbc connection
 
Share this answer
 
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900