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!
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
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!
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply