locked
SQL Management PAck - Discovery Failed RRS feed

  • Question

  • Hi

    I  installed the SCOM 2016

    I import the Management Pack for SQL 2012 and 2016

    I thought by default once I import , the SQL server will be monitored automatically

    Please advise how to fix this issues and what is the step by step if you have

    Error:

    MSSQL 2012: Discovery Failed

    MSSQL 2016: Discovery Failed

    MSSQL 2012: Monitoring Failed

    MSSQL 2016: Monitoring Failed

    Thanks in Advance


    Robert

    Monday, January 16, 2017 11:59 AM

Answers

  • The SQL MP needs an account setting up, profiles associated with that account and rights given to the instances. Kevin Holman gave the best explanation (as always). https://blogs.technet.microsoft.com/kevinholman/2010/09/08/configuring-run-as-accounts-and-profiles-in-opsmgr-a-sql-management-pack-example/

    
    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Tuesday, January 17, 2017 8:01 AM
  • Hi Sir,

    >>I thought by default once I import , the SQL server will be monitored automatically

    I assume that you have discovered server OS .

    SQL MP may needs to configure run as profile .

    For details please refer to "Run As Profiles" section in SQL MP guide:

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

    SQL MP 2016 :

    https://www.microsoft.com/en-us/download/details.aspx?id=53008

     

    In addition:

    https://blogs.technet.microsoft.com/kevinholman/2010/09/08/configuring-run-as-accounts-and-profiles-in-opsmgr-a-sql-management-pack-example/

    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.


    • Edited by Elton_Ji Tuesday, January 17, 2017 8:19 AM
    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Tuesday, January 17, 2017 8:15 AM
  • Hi Robert,

    My advise to you, before going through all the articles is to go through the MP guide first. Some MPs are tuned to monitor workloads automaticaly after being import and then need fine tuning. The SQL MP is a bit of different story as it carries more complexity that comes from the monitored workload: SQL.

    In the MP guide you will find detailed explaination of the steps needed to setup the MP properly or at least to get it working. This includes also profiles.

    There could be multulpe reasons for the faiing discover and accounts are just one of them. Please take a closer look at the errors and check what other details do they include.

    When you get to set up the profiles (as suggsted by the others here), please also consider this:

    SQL MP Run As Accounts – NO LONGER REQUIRED

    Regards,


    Stoyan (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!)

    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Tuesday, January 17, 2017 9:00 AM
  • Hi Robert,

    yes.

    Regards,


    Stoyan (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!)

    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Wednesday, January 18, 2017 11:41 AM

All replies

  • The SQL MP needs an account setting up, profiles associated with that account and rights given to the instances. Kevin Holman gave the best explanation (as always). https://blogs.technet.microsoft.com/kevinholman/2010/09/08/configuring-run-as-accounts-and-profiles-in-opsmgr-a-sql-management-pack-example/

    
    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Tuesday, January 17, 2017 8:01 AM
  • Hi Sir,

    >>I thought by default once I import , the SQL server will be monitored automatically

    I assume that you have discovered server OS .

    SQL MP may needs to configure run as profile .

    For details please refer to "Run As Profiles" section in SQL MP guide:

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

    SQL MP 2016 :

    https://www.microsoft.com/en-us/download/details.aspx?id=53008

     

    In addition:

    https://blogs.technet.microsoft.com/kevinholman/2010/09/08/configuring-run-as-accounts-and-profiles-in-opsmgr-a-sql-management-pack-example/

    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.


    • Edited by Elton_Ji Tuesday, January 17, 2017 8:19 AM
    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Tuesday, January 17, 2017 8:15 AM
  • Hi Robert,

    My advise to you, before going through all the articles is to go through the MP guide first. Some MPs are tuned to monitor workloads automaticaly after being import and then need fine tuning. The SQL MP is a bit of different story as it carries more complexity that comes from the monitored workload: SQL.

    In the MP guide you will find detailed explaination of the steps needed to setup the MP properly or at least to get it working. This includes also profiles.

    There could be multulpe reasons for the faiing discover and accounts are just one of them. Please take a closer look at the errors and check what other details do they include.

    When you get to set up the profiles (as suggsted by the others here), please also consider this:

    SQL MP Run As Accounts – NO LONGER REQUIRED

    Regards,


    Stoyan (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!)

    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Tuesday, January 17, 2017 9:00 AM
  • Thanks for info Guys

    Just quick question regarding the account

    The RunAs "account"  below must be a local admin and SQL admin "sysadmin" privilege  ?

      mydomin\sqlscom 

    Please advise


    Robert

    Wednesday, January 18, 2017 10:52 AM
  • Hi Robert,

    yes.

    Regards,


    Stoyan (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!)

    • Marked as answer by help.me.please Thursday, January 19, 2017 7:58 AM
    Wednesday, January 18, 2017 11:41 AM