Hi All, In my environment we using SCOM 2007R2. i added SQL 2005 & SQL 2008 servers in SCOM. I need to know what type of access required to monitor SQL databases thourgh SCOM 2007R2. kindly help me. ITs urgent. Regards, Sandy

Hi, You can find the MP here: http://www.microsoft.com/en-us/download/details.aspx?id=10631 Please read the Security Considerations on page 26 in the ServerMPGuide.doc file.Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Sandy Please find the below article from Kevin on the SQL MP http://blogs.technet.com/b/kevinholman/archive/2010/09/08/configuring-run-as-accounts-and-profiles-in-r2-a-sql-management-pack-example.aspx Donald D'souza (http://donald-scom.blogspot.com/)

Hi In the past the account that is monitoring needed SQL SysAdmin rights. This has changed for non-clustered SQL Servers in the latest version of the SQL MP although it is a long winded process to setup monitoring using a low privileged account: Official documentation: http://technet.microsoft.com/en-us/library/dd767431.aspx Kevins Blog article is a little out of date. The steps for configuring the Run As Accounts and Profiles haven't changed though and if you don't want to use the low privileged monitoring option then it is still 100% accurate in detailing how to set up these accounts. Cheers GrahamRegards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

HI Graham, So normally we need Sysadmin access to monitor the fulfledged SQL monitoring. Is that right. Regards, Sandy.