sql server management studio question mark on database

Question

_{Wednesday, March 20, 2019 1:10 PM}

Hi!

I have sql 2017 and mangament studio 17.9.1

When I try to connect to my instance I can see question mark on database. I can't restart or stop intance...

So..I check this:

https://docs.microsoft.com/en-us/sql/ssms/configure-wmi-to-show-server-status-in-sql-server-tools?view=sql-server-2017

but doesn't work

The only temporally way I found is add the user to sql server administrators....but not good solution.

The problem is know "user can get instance status.."

How i can do it without add user to server administrator?



thanks

All replies (3)

_{Wednesday, March 20, 2019 3:23 PM}

blue question mark indicates that SSMS does not know if the service is running or not, by way of a WMI call.  icon replaced the blank or white circle icon of prior SSMS versions.

https://dba.stackexchange.com/questions/176666/blue-icon-with-question-mark-what-does-it-mean

https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

---

_{Thursday, March 21, 2019 6:59 AM}

Hi,
SQL Server Management Studio uses WMI to query for information about the status of the services. You can enable below windows firewall rules to fix the problem.
Windows Management Instrumentation (WMI-In)
Windows Management Instrumentation (DCOM-In)
Please refer to how to Enable these Windows Firewall rules using powershell?
Best regards,
Cathy Ji

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

---

_{Thursday, March 21, 2019 12:20 PM}

Please see:

/en-us/sql/database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services?view=sql-server-2017#Permissions