This is more of an annoyance then a real problem but I have been looking at this for a long time and I really would like to fix this. The problem is that when I open SSMS and navigate to my registered SQL servers, I see that some of my registered servers are missing the green arrow.
Despite the little green arrow not showing up it has posed no connection problems to the SQL instances. I am still able to click on the server and navigate to all the objects within the instance with no problem.
I have sysadmin on all of these SQL servers so it is not a permissions issue. Also, this problem is not discriminating between the SQL servers in the DMZ or on the trusted network, it is happening on both.
So why is the little green arrow not showing up?