SQL 2008 R2 - Can't see services in SSCM or status of server in SSMS

Question

SQL 2008 R2 - Can't see services in SSCM or status of server in SSMS

chrisph

Hall of Fame

Points: 3701
More actions
January 28, 2013 at 2:59 pm

#288466

I was getting a WMI error launching SSCM so I followed the advice of this article and ran the mofcomp command: http://social.msdn.microsoft.com/Forums/en/sqlkjmanageability/thread/4c8ca86c-105f-4f0a-ac18-6e33dda2bc46
This resolved the WMI error but when I launch SSCM it comes up but I cannot see any services listed, and I have 3 instances running on this production server. Also in SSMS I have a white icon beside the server and SQL agent showing no status updates.
Please help

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113445 More actions · Answer 1

That would indicate that your account cannot enumerate if the services are started or not, which would relate to why you cant see them in SSCM.

What permissions does your account have on the actual windows box.

chrisph Hall of Fame Points: 3701 More actions · Answer 2

My account has local admin permissions on the box and sysadmin privileges to all the SQL instances. I logged in again this morning and got the WMI error again, I'm at a loss.

lkennedy76 SSChampion Points: 13683 More actions · Answer 3

Sounds like you need to do it again. below is a link. What happened before you tried going into SSCM? This might help us to identify your issue.

http://msmvps.com/blogs/martinpoon/archive/2009/11/27/sql-server-configuration-manager-cannot-connect-to-wmi-provider-invalid-class-0x80041010.aspx

MCSE SQL Server 2012\2014\2016

chrisph Hall of Fame Points: 3701 More actions · Answer 4

I've done it again and when launching SCCM I get "there are no items in this view" under the services or other options.

chrisph Hall of Fame Points: 3701 More actions · Answer 5

Guys... any one bump into not being able to view these services? I can see them through the windows services just fine but not SSCM and I'm concerned if I need to make edits through that soon.