locked
SCOM 2012 R2 : SQL 2008 R2 is not getting discovered in SQL 2012 6.5.1 MP RRS feed

  • Question

  • we are using SCOM 2012 R2 and SQL 2012 6.5.1 management pack for SQL monitoring.

    All of the SQL 2012 and R2 servers are getting discovered and monitoring is working fine with out any issue.

    But 2008 and 2008 R2 servers are not getting discovered, we have checked all the user level permissions are fine.

    Please give any suggestion to resolve the issue.
    Wednesday, January 6, 2016 5:11 AM

All replies

  • Hi Sir,

    Please check if 2008/R2 management pack was imported into SCOM .

    (You can download them here and import them   )

    Also please check whether or not SQL 2008/R2 object discoveries are enabled :

    Best Regards,

    Elton


    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 Elton_Ji Thursday, January 7, 2016 8:45 AM
    • Proposed as answer by paul-gilbert Monday, February 15, 2016 5:31 AM
    Thursday, January 7, 2016 8:27 AM
  • Hi Elton,

    Thanks for your answer. We have checked discovery jobs but there were no SQL 2008 related discoveries available. There is only SQL core & SQL 20012 discoveries available. And also checked the Management pack list there SQL 2012 MPs only available.

    Can you help me to root cause of the issue.

     


     

    Friday, January 8, 2016 7:10 AM
  • Hi there,

    Because there is no 2008 SQL MP .

    Try to download it :

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

    PAUL

    Monday, February 15, 2016 5:31 AM