locked
SQL MP script failed to run RRS feed

  • Question

  • Hi! I have installed the SQL MP 6.5.1.0 for SQL2005,SQL2008,SQL2012 and SQL2014. I know that I need to use one SQL RunAsAccount and add that account in the SQL RunAsProfiles to have the correct access to run the SCOM SQL scripts and get the correct monitoring. We have give this SQL RunAsAccount the "Local Administrator" and "sysadmin" rights on all instances through a group. This SQL servers also use UAC, then we tested to add this SQL RunAsAccount directly with sysadmin rights on one SQL servers instances instead through a group. But still the same problem... I haven't test the new SQL MP version 6.5.4.0 yet and I know that there is one fix for "Fixed Timeout error in CPU utilization monitoring scenario"

    The SQL RunAsAccount use "More Secure" and we are running the SQL RunAsProfiles target type against a Group with "Windows Computers" for all the SQL servers that we want to run this RunAsAccount against. We have the same problem when we tested to change the target type to "SQL Computers" 

    At most of our customer it works fine but at one customer we still get all this SQL monitor related errors:

    • Power Shell Script failed to run (timeout 200 sec)

            - scriptname=CPUUsagePercentDataSource.ps1

            - workflow=Microsoft.SQLServer.2008DBEngine.ThreadsCountMonitor

    • Operations Manager failed to start a process

           - command=GetSQL2008DBWinServStat.js

           - workflow=Microsoft.SQLServer.2008.Database.ServiceMonitor

    • Operations Manager failed to start a process due to lack of Resources

           - command=GetSQL2012DBFreeSpace.vbs

    • Operations Manager failed to run a WMI Query

             - workflow=Microsoft.SQLServer.2012.Database.ServiceMonitor

    Someone with any idea what's the problem can be?

    Wednesday, March 18, 2015 8:28 AM

Answers

  • Hi,

    >At most of our customer it works fine but at one customer we still get all this SQL monitor related errors

    Do you mean only one SQL server has this error message poped out? If that is the case, then you may check whether the runas account configured has proper permissions on that server. You may add the account to local admin group.

    Please also go through the link below:

    http://blogs.technet.com/b/kevinholman/archive/2013/10/24/opsmgr-sql-mp-version-6-4-1-0-capabilities-and-configuration.aspx

    Regards,

    Yan Li


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    • Edited by Yan Li_ Friday, March 27, 2015 6:13 AM edit
    • Proposed as answer by Yan Li_ Friday, March 27, 2015 6:13 AM
    • Marked as answer by Yan Li_ Tuesday, March 31, 2015 8:16 AM
    Tuesday, March 24, 2015 7:17 AM

All replies