白色圆圈通常包含绿色箭头、蓝色暂停符号或红色正方形,分别表示SQL Server服务正在运行、已暂停或已停止。
通常安全设置会只允许管理员查看服务状态,所以普通用户无法访问该信息。因此SSMS显示一个空白的白色圆圈,意味着服务处于不确定状态(从它的角度来看)。当然,如果您能够连接到服务并运行查询,则服务必须在运行中,所以不用担心这个问题。
请参阅这里:http://www.sqlservercentral.com/Forums/Topic825246-146-1.aspx
SQL Server Management Studio使用WMI查询有关服务状态的信息。
If it’s a local machine, then make sure you are using “Run as administrator” option. and check if sure “Windows Management Instrumentation” service is running under services.msc on the server.
check that if the firewall is not blocking WMI communication. Now, Run WMI query to make sure we are able to query services. Below are the steps.
1. Start > Run > WBEMTest 2. Click on Connect and provide below (change Remote Machine Name and ComputerManagement<Number> based on SQL version. \\{servername}\root\Microsoft\SQLServer\ComputerManagement13 3>Click Connect 4>Click on Query 5>Type Select * from SQLService and Apply. You should see the results.
If you have a problem with above that it's confirmed WMI issue.
Make sure that you are able to open SQL Server Configuration Manager, which uses WMI.
我在 SQL Server 2014 中遇到了这个问题,我按照以下步骤解决了它
1. Access SQL Server Configuration Manager
2. Under SQL Server Services, start the SQL Server Agent(make sure the start mode is automatic).
启动后,SQL Server代理的红色警报消失了,数据库服务器上也出现了绿色播放图标。
我只需要重新启动SQL Server Management Studio (SSMS),就可以再次显示状态。
这是给新用户的。如果你遇到同样的问题,最好手动启动Sql Browser服务,检查用户访问权限,检查所需端口是否已启用。任何一个解决方案都可能有帮助...
您需要在防火墙上启用所有必需的端口;)