SQL Server in Computers view but not in SQL Computers view
-
Monday, July 16, 2012 10:46 AM
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.
All Replies
-
Monday, July 16, 2012 10:58 AMModerator
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):
- check the SQL Error log for failed login errors
Cheers
Graham
Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/ -
Monday, July 16, 2012 12:46 PM
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!
-
Monday, July 16, 2012 1:22 PMModerator
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:
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
Graham
Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/- Proposed As Answer by Nicholas LiMicrosoft Contingent Staff, Moderator Tuesday, July 17, 2012 8:06 AM
-
Tuesday, July 17, 2012 8:07 AMModerator
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.aspxWMI: Rebuilding the WMI Repository
http://blogs.technet.com/b/askperf/archive/2009/04/13/wmi-rebuilding-the-wmi-repository.aspxHope this helps.
Thanks.
Nicholas Li
TechNet Community Support
-
Monday, July 23, 2012 3:46 PM
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...
I need to investigate further and get rid of that Invalid Class error so that query works...
-
Tuesday, July 24, 2012 8:32 AM
Further to this, looking at the WMI Query on this page...
http://ochoco.blogspot.co.uk/2009/03/how-to-detect-sql-server-instances.html
The namespace seems to be \root\Microsoft\SqlServer\ComputerManagement
I seem to have \root\Microsoft\SqlServer but not the ComputerManagement part at the end - getting Invalid NameSpace when trying to use that in wbemtest.
I have previously been through the WMI rebuilding instructions posted above but I still seem to be missing something!
-
Tuesday, July 24, 2012 8:40 AMThe namespace for SQL 2008 is root\Microsoft\SqlServer\ComputerManagement10 - which I can connect to fine - wbemtest now reports that I have access denied when running the SQL query in that namespace - I'm glad I've gone through the steps to get here - the original WMI diagnostics did look a mess and seem much healthier after rebuilding - so I'm getting somewhere I think!
-
Tuesday, April 02, 2013 10:34 AM
Hi - I know this is an old post but did you get anywhere with this as I am experiencing exactly the same problem
Thanks
.png)
