SQL Server Management Studio WMI Issue?

[DigitalFool]

I have an issue that I've been scratching my head with the past few days.

Just recently, all my registered servers no longer show the started/stopped status in SQL Server Management Studio. Even when I connect, I can browse the database fine, but again, the icon is empty. (This also includes all the agents)

The only server that shows started is a local express instance I have installed. I have a colleague with the same issue (but in SQL 2008).

Locally on each server, the icons appear.

The only major change is I installed the WMI Installer Provider as a prerequisite for Microsoft Asset Planner on the database servers. Is the database status updated via WMI?

I uninstalled the WMI Installer Provider from one the servers, but still the same issue. WMI service is started.

Any ideas?

 

[JayKusch]

Did we ever get a solution to your problem at hand?

If not, may I ask for some clarification?

When you say "no longer show the started/stopped status in SQL Server Management Studio" ... are you talking about the Green circle with the white arrow within that shows a server is startered?

Thanks

J. Kusch

 

[DigitalFool]

Yes, I am missing the icon status, the circle is there, just empty.

I have some more information.

I realized that MAP installed SQL 2008 express in order to run. That is the only instance that is showing started. I no longer am using MAP on my machine, so I removed it. I also removed the SQL 2008 parts and I'm still having the same issue. So now I'm thinking this is in no way related to WMI.

Am I looking at a 2005/2008 conflict? I just use tools on my machine to manage the 2000/2005 instances. Currently there are no production 2008 instances.

I guess I'll have to do some more digging with 2005/2008 installs.