locked
SQL 2016 Monitoring - SCOM 2012 RRS feed

  • Question

  • <g class="gr_ gr_19 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="19" id="19">hello</g> guys,

    I have been assigned a task to start the complete SQL 2016 monitoring with SCOM 2012.

    I have downloaded the Management pack and imported in SCOM. I am seeing monitoring failed or discovery failed error message in alert view and looks like a permission issue to me.

    I am seeing frequent critical alerts event id 7105 & Event id 4211

    Please suggest.


    Friday, September 29, 2017 5:08 AM

All replies

  • Hi,

    Did you remember Runas account?

    SQL MP Run As Accounts – NO LONGER REQUIRED

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

    Page 23 in SQLServer2016MPGuide.docx

    Microsoft System Center Management Pack for SQL Server 2016

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

    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.

    • Proposed as answer by Elton_Ji Tuesday, October 10, 2017 2:47 AM
    Friday, September 29, 2017 6:09 AM
  • Hi,

    Also , please check the following article which detailed the quick config for SQL discover/monitor :

    https://blogs.msdn.microsoft.com/tysonpaul/2016/04/09/sql-run-as-account-configuration-for-scom-made-easy/

     

    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.

    Monday, October 2, 2017 2:25 AM