SSMS Object Explorer Icons
-
After so many years of working with SQL Server, I should know the answer to this one, but I don't.
I'm connected to QA and Prod servers, and, in Object Explorer, the icons look like this
The connection to QA seems to be in a 'known' good state, whereas the connection to Prod has a blue question mark against it.
Each of these connections is to a different SQL Server instance on different VMs.
Any ideas what needs to happen to make my Prod connection icon turn green?
Thanks!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
-
Yes it's about wether WMI Service State queries work or not.
Enabling these Windows Firewall rules
Windows Management Instrumentation (WMI-In)
Windows Management Instrumentation (DCOM-In)
on your prod environment should turn the Icon green.
- DinoRS wrote:
Yes it's about wether WMI Service State queries work or not.
Enabling these Windows Firewall rules
Windows Management Instrumentation (WMI-In)
Windows Management Instrumentation (DCOM-In)
on your prod environment should turn the Icon green.
Thank you very much for the assistance, this worked!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply