So, I've been trying to solve the blue icon question mark on my sql server in SQL Server Management Studio by following the answer in the following link:
after executing the above recommended answer I was still unable to resolve this question mark icon issue and to prove that it was related to the WMI I followed these steps:
In windows Start > Run > WBEMTest
Type the following under namespace
Click on "Query..."
Select * from SQLServiceand Apply
I get 0 rows
What does this mean? what else am I missing?
This is what I have tried so far:
- Added my windows user to the
Distributed COM Usersand
Performance Monitor Users
- in my sql server machine, I opened the WMI Control and gave permissions to group
Performance Monitor Usersso that they could have
Remote Enableaccess to the namespace and subnamespaces on :
- Verified that the WMI service is running in the sql server machine
- TCP Port 135 is enabled and open in the guest machines
Windows Management Instrumentation (DCOM-In)and
Windows Management Instrumentation (WMI-In)Inbound rule is enabled in the guest machines firewall.