重新启动后无法远程或本地连接到 SQL Server [英] Cannot connect to SQL Server remotely or locally after reboot

问题描述

经过上周末的一些网络维护，我们的开发服务器出现了一些问题，导致我们重新启动了它.在重新启动期间安装了一些更新，这可能是也可能不是一个因素.从那时起，我们一直无法连接到 SQL Server 2005，甚至无法通过 Management Studio 本地连接.根据用于连接尝试的协议，我们会收到以下两个错误之一:

1. 当您尝试使用命名管道协议或共享内存协议连接到实例时，您收到以下错误消息:

<块引用>

管道的另一端没有进程.

2. 当您尝试使用 TCP/IP 协议连接到实例时，您收到以下错误消息:

<块引用>

现有连接被远程主机强行关闭.

上述协议都开启了，SQL服务都运行得很愉快(除了SQL Server Agent，也连接不上SQL Server).我们还检查了表面积配置工具以确保它接受连接.

这不是证书问题(如在线所见)，因为我们不使用加密连接.

有什么建议吗?否则，我们可能会诉诸于完全重新安装.

** 更新 **

更多线索:

• 我们可以连接到集成服务，但不能连接其他
• 我们可以连接到运行在同一台服务器上的 SQL Server Embedded Edition 实例

解决方案

验证 SQL Browser 服务是否正在运行.很可能它没有设置为自动启动.

您可能需要查看它的属性以验证它正在侦听正确的网络接口.

运行 SQL Server 配置管理器.在 SQL Server 2005 网络配置下，您将看到 4 个协议.然后转到 TCP/IP 的属性.你应该能够从那里弄清楚.

失败的唯一原因是 SQL Server 服务或 SQL Server Browser 服务未运行或浏览器服务配置错误.

**** 更新 ****另一种可能性是使用防火墙.请务必关闭 windows 防火墙，然后重试.

After some network maintenance last weekend, we had some trouble with our development server which led to us restart it. Some updates were installed during the restart, which may or may not have been a factor. Since then, we have been unable to connect to SQL Server 2005, even locally via Management Studio. Depending on the protocol used for the connection attempt, we get one of the following two errors:

1. When you try to connect to the instance by using the named pipes protocol or the shared memory protocol, you receive the following error message:

No process is on the other end of the pipe.

2. When you try to connect to the instance by using the TCP/IP protocol, you receive the following error message:

An existing connection was forcibly closed by the remote host.

The aforementioned protocols are all enabled, and the SQL services are all running happily (apart from the SQL Server Agent, which cannot connect to SQL Server either). We also checked the Surface Area Configuration tool to ensure it accepts connections.

It's not a certificates problem (as seen online) as we don't use encrypted connections.

Any suggestions? Otherwise we will probably resort to a full reinstall.

** UPDATE **

Further clues:

• We can connect to Integration Services, but nothing else
• We can connect to the instance of SQL Server Embedded Edition running on the same server

解决方案

Verify that the SQL Browser service is running. Most likely it's not set to Auto Start.

You might want to look in it's properties to verify it's listening on correct network interface.

Run the SQL Server Configuration Manager. Under the SQL Server 2005 Network Configuration, you will see 4 protocols. Then go to properties for TCP/IP. You should be able to figure it out from there.

The only reason for this to fail is if the SQL Server service or SQL Server Browser services aren't running or if the browser service is misconfigured.

**** UPDATE **** Another possibility is the use of a firewall. Be sure to turn off the windows firewall, then try again.

这篇关于重新启动后无法远程或本地连接到 SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！