I have tried to Google this issue for quite awhile and can't find any definitive solution. Now in my management studio on my workstation, the icon on the server instance is simply a blank white circle with no green arrow in it. I logged on as 'sa' and I can't use right-click the instance icon to select "start", "stop", "pause", "resume" or "restart" because they are all grayed out. But all the rest operations are available.
One of the explanations that I can find online is that in this situation, the management studio can't retrieve the info whether the SQL Server service is running on the server or not. But when I use remote desktop to connect to the server itself, the green arrow is well and fine in the management studio in the remote session.
So can there be any firewall settings on the server that prevent the SQL Server service running state being communicated to my workstation?
Where should I look more into then?
Thanks for your inputs in advance!