I'm using SCOM 2012. I have a computer with SQL 2008 R2 installed on it and the SCOM agent is installed and running as Local System on it. That computer appears in the computer view in monitoring but it doesn't appear in the SQL Server Computers view - the SQL Agent isn't listed either. I have several other SQL servers which are all listed as expected and I'm struggling to work out why this particular server doesn't have it's SQL components listed.

Hi A few things to check: - are there any errors in the OperationsManager event log on the SQL Server in question. This is in Start, Run, Eventvwr --> Applications and Services Logs, Operations Manager - check the Run As Account has been setup correctly and distributed to the SQL Server (it might be that security is configured differently on this SQL Server): http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx - check the SQL Error log for failed login errors Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Hi, thanks for that. I've found this error in the Operations Manager logs... DiscoverSQL2008DBEngineDiscovery.vbs : The Query 'select * from SqlService where SQLServiceType ='1'' did not return any valid instances. Please check to see if this is a valid WMI Query.. Access is denied. I'm trying to dig a little further but any more ideas greatefully received!

Hi "Access is denied." looks key here - check that the Run As Account specified has log on locally rights to the SQL Server and is a SQL Server SysAdmin: http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx Perhaps you can try loging on to the server using the Run As Account and then: 1) Start, Run, WEBMTest 2) Run the Query 'select * from SqlService where SQLServiceType ='1' to check that you get the same error. Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Hi, In addition, regarding checking WMI related issues, please also refer to the following posts: WMI Troubleshooting: The Repository on Vista / Server 2008 http://blogs.technet.com/b/askperf/archive/2008/07/11/wmi-troubleshooting-the-repository-on-vista-server-2008.aspx WMI: Rebuilding the WMI Repository http://blogs.technet.com/b/askperf/archive/2009/04/13/wmi-rebuilding-the-wmi-repository.aspx Hope this helps. Thanks. Nicholas Li TechNet Community Support

Thanks for all the help so far - I'm trying to fit in looking at this betweens lots of other things (as I'm sure you can all imagine!) All of the user and SQL permissions checked out fine - I couldn't find anything wrong there. Running WBEMTest and typing that query, I get 'Invalid Class' - 0x8004010 I did try the instructions in this article to no avail... http://blogs.msdn.com/b/spike/archive/2012/03/19/quot-sql-server-configuration-manager-quot-gives-quot-invalid-class-0x80041010-when-starting.aspx I need to investigate further and get rid of that Invalid Class error so that query works...