Sql server 2008连接问题 [英] Sql server 2008 connectivity issue

问题描述

嗨



我们正在连接到sql server的web应用程序，我们与服务器的连接不稳定，有时我们能够连接，有时我们得到端口1051的错误消息如下



建立与SQL Server的连接时发生与网络相关或特定于实例的错误。未找到服务器或无法访问服务器验证实例名称是否正确并且SQL Server配置为允许远程连接。（提供程序：TCP提供程序，错误：0 - 连接尝试失败，因为连接方在一段时间后没有正确响应，或建立连接失败，因为连接的主机无法响应。）（Microsoft SQL Server，错误：10060）







你能建议



谢谢



我尝试过：



我们尝试启用禁用防火墙，为端口添加例外tivirus但没有运气。是否有任何其他设置或安装问题

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

推荐答案

这样的间歇性问题通常是客户端（您的Web服务器）与SQL服务器之间的网络连接不良< br $>


或



您已经用尽了客户端上的连接池或SQL服务器的限制，可能是因为你完成后没有关闭连接。



或



你SQL Server出现性能问题，无法及时响应新连接。





来自你发布了什么，不可能给你一个关于什么是错的具体答案。这将需要您进行更多的故障排除。



我可以告诉您的是，这种问题从未有可能成为防病毒或防火墙问题。

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.

转到所有程序>> Microsoft SQL Server>>客户端网络实用程序>>将协议TCP / IP更改为1433或设置odbc连接

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

这篇关于Sql server 2008连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！