SQL Server 2008突然停止连接
这很奇怪......
我家里有一台服务器，它是我的家庭网络（工作组）的一部分。它运行的是 SQL Server 2008 R2 SP1。几个月来我一直定期从我的（其他）桌面连接到它，今晚突然我无法从我的桌面连接到它。如果我通过 RDP 连接到服务器并在本地进行连接，我可以连接到它。我检查了服务器上的事件日志，没有出现任何有趣的内容。
这是尝试连接到服务器时 Management Studio 从我的桌面返回的（无用的）错误：
超时已过。超时时间在完成之前已过 操作或服务器没有响应。 （.Net SqlClient 数据 提供商）
我真的有点难住了。我尝试使用 sqlcmd 连接 - 它告诉我：
Sqlcmd：错误：Microsoft SQL Server Native Client 10.0：无法 由于打开服务器连接延迟而完成登录过程。
不太确定这意味着什么。我已确保 SQL Server 配置为允许远程连接，并使用 netstat -a 并看到它正在侦听端口 1433（对于所有 IP）。
有人有任何有用的想法吗？我也重新启动了服务器，但这并没有改变任何东西。
编辑/更新：从我的桌面我可以通过主机名 ping 服务器，我得到如下信息：
来自 fe80::9077:4449:4b37:cad1%12 的回复：时间<1ms
但如果我尝试通过它的 IP 地址对其进行 ping 操作，则会超时。我想知道这是否表明存在某种 IPv4 与 IPv6 问题？
This one is strange...
I have a server at home that's part of my home network (workgroup). It has SQL Server 2008 R2 SP1 running on it. I've been connecting to it from my (other) desktop regularly for months now and tonight all of a sudden I can't connect to it from my desktop. I can connect to it if I RDP onto the server and connect locally. I've checked the event logs on the server and nothing interesting appears.
Here's the (unhelpful) error returned by Management Studio from my desktop when trying to connect to the server:
Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding. (.Net SqlClient Data
Provider)
I'm kinda stumped by this really. I've tried connecting with sqlcmd - it tells me this:
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Unable to
complete login process due to delay in opening server connection.
Not really sure what that means. I've made sure SQL Server is configured to allow remote connections and have used netstat -a and seen that it's listening on port 1433 (for all IPs).
Anyone got any helpful ideas? I've rebooted the server too, but that didn't change anything.
EDIT/UPDATE: from my desktop I can ping the server by host name and I get something like this:
Reply from fe80::9077:4449:4b37:cad1%12: time<1ms
but if I try to ping it by it's IP address it times out. I wonder if that points to some kind of IPv4 vs. IPv6 issue?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
从您的桌面解析的IP地址是服务器的实际IP地址吗？
从服务器运行
ipconfig /all，然后从桌面执行nslookup以查看 IP 地址是否匹配。我遇到过 DNS 混乱、IP 地址解析错误的情况。Is the IP adress resolved from your desktop the actual ipadress of the server ?
Run a
ipconfig /allfrom the server, and do anslookupfrom your desktop to see if IP addresses are matching. I had cases when the DNS was messed up, and IP address resolution was wrong.