SQL Server“未知正在运行”
当我尝试使用企业管理器连接到 SQL Server 时，我收到奇怪的消息：
“SQL Server 未知正在运行。您确定要连接吗？”
它想告诉我什么？
尝试连接到未知正在运行的服务器时是否需要特别小心？如果是这样，在尝试连接服务器之前如何确定服务器是否正在运行，以及为什么企业管理器不提供此服务？
When I attempt to connect to SQL server using enterprise manager I get the strange message:
"SQL Server is not known to be running. Are you sure you want to connect?"
What is it trying to tell me?
Is there some special caution required in trying to connect to a server that is not known to be running? If so, how do I find out if a server is running before trying to connect to it, and why doesn't enterprise manager provide this service?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
它只是告诉您它无法验证服务器是否正在运行，并且如果服务器关闭（或者有防火墙，或者网络关闭等），连接可能会失败。
您只需单击“确定”即可继续。
请参阅此帖子和此 了解更多详细信息。
It is simply telling you that it could not verify that the server is running and that a connection may fail in the eventuality that the server is down (or there is a firewall, or the network is down etc...).
You can simply click OK and let it continue.
See this post and this one for more detail.
企业管理器在后台线程上与每个服务器实例通信以确定其当前状态。您可以在屏幕上看到这种情况发生 - 图标最初是空白的，然后当 EM 知道其状态时，根据需要更改为绿色或红色。
如果您在图标仍为白色时连接到服务器实例，则 EM 会告诉您它还没有时间获取当前状态。
就我个人而言，我不认为这样做有什么意义，您将在几秒钟内发现它是否正在运行。 :-)
Enterprise Manager communicates with each server instance on a background thread to determine its current state. You can see this happening on screen - the icon is blank at first, then changes to either green or red as appropriate when EM knows its state.
If you connect to a server instance when the icon is still white, then EM tells you that it hasn't had time to get the current state yet.
Personally I don't see the point of doing this, you will find out within a few seconds whether it's running or not anyway. :-)