locked
Monitoring and discovery failed alerts RRS feed

  • Question

  • Hi All,

    I've imported management packs for SQL in SCOM few days back. However, followed by import, i've following types of SCOM alerts opened almost for all the database servers. Can anybody help me with the resolution please? Many thanks.

    MSSQL: Monitoring failed

    MSSQL 2012: Discovery failed


    Tuesday, June 27, 2017 1:38 PM

All replies

  • Hi Sir,

    I'd suggest you follow the SQL MP guide to configure SQL MP :

    https://www.microsoft.com/en-sg/download/details.aspx?id=10631

    (You may aslo import windows operating system management pack )

    Best Regards,

    Elton


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

    Wednesday, June 28, 2017 3:04 AM
  • Most likely is the security issue. Your SQL default action account has not enough privilege. Pls. refer to SCOM MP guide to config your action account.
    Roger
    Wednesday, June 28, 2017 3:50 AM
  • Thanks Elton for the suggestion.

    I went through the complete MP guide however i didn't find any such variations in my environment.

    Would you able to tell me what additional rights are required for default SCOM action account. Many thanks.

    Wednesday, June 28, 2017 12:32 PM
  • I suggest to read this 

    https://blogs.technet.microsoft.com/kevinholman/2016/08/25/sql-mp-run-as-accounts-no-longer-required-2/

    • Proposed as answer by Elton_Ji Tuesday, July 25, 2017 3:51 PM
    Wednesday, June 28, 2017 12:39 PM