DiggityShmoo (9/6/2011)

---

I was having this problem on a development SQL server. Permissions were all correct, and i was able to manage the services remotely using the windows services management console, and the sql service configuration manager, but i was unable to view or modify the service status through the management studio.

The server I'm working on is going to replace an existing server, so it's currently running with a temporary hostname that isn't in DNS. This means I've had to connect to it using the IP address. I found that by adding the server to my hosts file and connecting by name instead of IP, i now get the green arrow and I can manage the instance through SSMS. Not sure why that makes a difference, but it worked for me!

Schadenfreude-Mei (9/7/2011)

---

interesting. I'll give that a go later.

Erik Edvalson (1/14/2013)

---

I know that this thread has gone stale without replies for quite some time. However, I was having this same problem and I figured it out. This may or may not resolve the problem that the orginal poster had but here is what I had to do.

1. Open Control Panel and then double click the Windows Firewall icon to open the Windows Firewall control panel.
2. In the upper left, click Allow a program through Windows Firewall. This will open up the Windows Firewall Settings window.
3. Select the Exceptions tab, if it isn't already selected. Scroll down and make sure that Windows Management Instrumentation (WMI) is checked.
4. Click OK or Apply.

That's all I had to do. Hope this is helpful.