Answered by:
SCOM 2016 server Prerequisite requirement for alert management system

Question
-
I want to build SCOM 2016 server for Monitoring MS SQL server alert Management.
Like service down, database down, Agent not working something we will get alert.
Please give me suggestion, how to build the server and post installation like how to configure alerts for all windows servers like IIS and MS SQL Servers.
what is the Prerequisite like what kind of logins ...etc.
Thanks in advance
Vijay
- Edited by VBRS Monday, July 23, 2018 6:04 PM
Thursday, July 19, 2018 6:31 PM
Answers
-
Hi,
The short answer is: build a SCOM environment and import the SQL management pack.
But I will recommend you to start with Kevin's guide:
Operations Manager 1801 – Quickstart Deployment Guide
SQL MP Run As Accounts – NO LONGER REQUIRED
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 SystemCenter User Friday, July 20, 2018 2:55 AM
- Marked as answer by Stoyan ChalakovMVP Friday, September 14, 2018 1:59 PM
Thursday, July 19, 2018 8:24 PM
All replies
-
Hi,
The short answer is: build a SCOM environment and import the SQL management pack.
But I will recommend you to start with Kevin's guide:
Operations Manager 1801 – Quickstart Deployment Guide
SQL MP Run As Accounts – NO LONGER REQUIRED
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 SystemCenter User Friday, July 20, 2018 2:55 AM
- Marked as answer by Stoyan ChalakovMVP Friday, September 14, 2018 1:59 PM
Thursday, July 19, 2018 8:24 PM -
Your objective is achievable, like service down, database down, agent not working something we will get alert, when you built up SCOM 2016 server and import SQL MP.
- Microsoft System Center Management Pack for SQL Server
https://www.microsoft.com/en-hk/download/details.aspx?id=10631
- Microsoft System Center Management Pack for SQL Server 2014
https://www.microsoft.com/en-hk/download/details.aspx?id=42573
- Microsoft System Center Management Pack for SQL Server 2016
https://www.microsoft.com/en-us/download/details.aspx?id=53008
- Microsoft System Center Management Pack for SQL Server 2017+
https://www.microsoft.com/en-us/download/details.aspx?id=56203
RogerFriday, July 20, 2018 2:20 AM - Microsoft System Center Management Pack for SQL Server
-
Hi,
Yes, correct, we just need to deploy the SCOM and import the corresponding MPs for SQL server. If we are using cluster, the cluster MP is required.
Microsoft System Center Management Pack for Windows Server Operating System 2016 and 1709 Plus
https://www.microsoft.com/en-us/download/details.aspx?id=54303
For more 2016 MPs, we may refer to the following link:
Where are the Server 2016 Management Packs?
https://blogs.technet.microsoft.com/kevinholman/2016/12/19/where-are-the-server-2016-management-packs/
For more other MPs, we can refer to this link:
Microsoft Management Packs
http://social.technet.microsoft.com/wiki/contents/articles/16174.microsoft-management-packs.aspx
Hope the above information helps.
-----------------------------------------------
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 AlexZhu_775Microsoft contingent staff Friday, July 20, 2018 3:22 AM
Friday, July 20, 2018 3:21 AM