SQL Servers and Cluster is not appearing Under SQL Management pack
Hi All, Most of the SQL machines are not apparing under the SQL (2005,2008)management pack under monitoring pane. Even cluster also not appearing. Agent action account is under local admin privilage in the respective servers and it has the sysadmin privilage. I have enabled the agent proxy in the properties of the agent. Could any one let me know what are the steps that i to follow to get the sql servers and cluster appear in the console. Regards, sankaSanka Perera
February 28th, 2011 3:51pm

Hi Check the operationsmanager event log on the SQL Servers for discovery errors. I would also say to look at the Run As Profiles for SQL - default, discovery and monitoring - but if you definitely have SYSTEM with SQL Sysadmin rights then that should be enough without any other configuration.. http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx You might want to consider importing the cluster MP as well but that is a seperate issue. SQL should be discovered (whether on a cluster or not) without the cluster mp being installed. Cheers GrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 7:22pm

Hi Graham, Since the local admin has the sysadmin privillage why should i create run as pofile again. Agent is installed in the SQL servers which are not appearing and its status is healthy. You want me to re-discover the servers again? Regards,Sanka Perera
March 2nd, 2011 4:14pm

Hi Sanka Can you check the operationsmanager event log on the SQL Servers for SQL discovery errors. The agent being healthy doesn't mean that the discoveries are running successfully so could you look for anything that indicates that a script failed to complete or access denied. Thanks Graham View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
March 2nd, 2011 4:29pm

So I am assuming that the cluster MP is installed and you said agent proxy is enabled. On your clusters, is cluster event log replication turned off? I find that this step seems to be missed by build teams. How can you tell if it's on? On any node, look at the event log and you will see other nodes writing to the logs. Check for WMI namespace issues. We had an issue where the C name of the cluster was using a 0 instead of a O. IE Cluster name contains maybe the letter 'O'. All names, even the name of the physical machine are using the O, but in cluster admin, the cluster name or something, I can't remember, but you can rename it, contained a '0' (zero). This value is what was being imputed in WMI. The WMI namespace being called by the discoveries by SCOM would fail and say the name was invalid. It was hard to spot, but when I see WMI namespace issues on clusters I suspect something regarding the clusters node physical names, registered names (dns etc), and virtual instance names. Tell this to a cluster guy and he will tell you SCOM is broken, not his box, then the problem magically dissapears in a few days (if they are good). Graham is also correct in asking you to look for those workflow failures (for discoveries as well as others) in the ops manager event log.Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/
March 4th, 2011 8:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics