Step-by-Step – Installing System Center Operations Manager (SCOM) 2016 on Windows Server 2016 with SQL 2016

This post I will be installing System Center Operations Manager 2016 (SCOM) RTM, Build Number 7.2.11719.0.

Here is some of the background information. As this post will concentrate on the installation of SCOM 2016, I am going to omit the setup and configuration of the Domain Controller, Windows Server 2016 for both SCOM Management Server and SQL Server (Please note, I am using SQL Server 2016, both servers on Windows 2016).

If you need help setting up SQL 2016 for SCOM 2016, please visit HERE.

Environment:  Virtual; ESX 6.0 Hypervisor

SCOM Management Server:

  • Windows Server 2016
  • 4 vCPU (2.00GHz)
  • 12 GB memory
  • 100GB Diskspace
  • 1GB vNIC

SQL Server:

  • Windows Server 2016
  • SQL Server 2016
  • 4 vCPU (2.00GHz)
  • 24 GB memory
  • 300GB Diskspace
  • 1GB vNIC

Service Accounts and Local Administrator:

Domain\Account Description Local Admin on…
domain\SCOM_AA SCOM Action Account SCOM & SQL
domain\SCOM_DA SCOM Data Access/SDK Account SCOM & SQL
domain\SCOM_SQL_READ SCOM SQL Reader SQL
domain\SCOM_SQL_WRITE SCOM SQL Writer SQL
domain\SCOM_Admins SCOM Administrators Group SCOM
domain\SQL_SA SQL Service Account SQL
domain\SQL_SSRS SQL Service Reporting Services Account SCOM

 

Now, if you’re lazy like me, or are tired of doing this setup for environments, I have scripted the automation of these accounts. You can find that link here, Microsoft TechNet Gallery.


Let’s Begin:

2

3

For completeness, let’s install all the features of SCOM 2016. (I am hosting a default SQL 2016 instance on the SCOM Management Server for SSRS)

4

5

Well, that’s not new… Errors. Since this is a clean, vanilla Windows 2016 server, we will need to install all the necessary Web Console components, along with Report Viewer Controls (probably SQL CLR Types too..).

  • For the Report Viewer Prerequisites, go HERE.

Note, oddly I was unable to install with CLR SQL 2016, Reports Viewer still complained and required CLR SQL 2014.

  • Here is the PowerShell command I ran to install the necessary IIS features/roles:
Import-Module ServerManager
Add-WindowsFeature Web-Server, Web-WebServer, Web-Common-Http, Web-Default-Doc, Web-Dir-Browsing, Web-Http-Errors, Web-Static-Content, Web-Health, Web-Http-Logging, Web-Log-Libraries, Web-Request-Monitor, Web-Performance, Web-Stat-Compression, Web-Security, Web-Filtering, Web-Windows-Auth, Web-App-Dev, Web-Net-Ext45, Web-Asp-Net45, Web-ISAPI-Ext, Web-ISAPI-Filter, Web-Mgmt-Tools, Web-Mgmt-Console, Web-Mgmt-Compat, Web-Metabase, NET-Framework-45-Features, NET-Framework-45-Core, NET-Framework-45-ASPNET, NET-WCF-Services45, NET-WCF-HTTP-Activation45, NET-WCF-TCP-PortSharing45, WAS, WAS-Process-Model, WAS-Config-APIs -restart

 

Once the server is back online, you will need to register ASP.Net.

6

You will need to apply the following using Command Prompt (as Administrator)).

  1. cd %WINDIR%\Microsoft.NET\Framework64\v4.0.30319\
  2. aspnet_regiis.exe -r
  3. IISRESET
  4. Reboot your server…

Once the server is back online, let’s try that Prerequisites check again….

7

Great! Now all of Prerequisites have been met!

8

Provide a meaningful Management Group Name (there’s no going back after this…)

9

SQL Server will be where your SCOM SQL instance(s) were installed. For me, I have built two instances on my SQL2016 server (SCOM_OPSMGR & SCOM_DW).

10

11

12

13

14

15

16

17

I recommend always keeping this off, and manually updating your SCOM infrastructure.

18

One quick review. Looks good. Hit Install, and get some fresh air!

19

A few minutes later….

20

Sweet! All good. I hope this helps. If you have any questions or issues, please drop me a line.

Please note, it is STRONGLY ADVISED to install the Update Rollup 1 once you have deployed SCOM 2016. For that walk-through, please visit the following post, HERE.

Happy 2016 SCOM’ing!

21

22

Advertisement

58 thoughts on “Step-by-Step – Installing System Center Operations Manager (SCOM) 2016 on Windows Server 2016 with SQL 2016

    1. Hi Alessandro,

      Did you follow the steps as mentioned above?

      You will need to apply the following using Command Prompt (as Administrator)).

      1. “cd %WINDIR%\Microsoft.NET\Framework64\v4.0.30319\“
      2. aspnet_regiis.exe -r
      3. IISRESET
      4. Reboot your server…

      Like

      1. Yea turns out the check box on the ASP .NET 3.5 was still unchecked! Thanks for the guide! Really Helped!

        Like

  1. Hi Ravi,

    I will be soon building a SCOM 2016 environment and have read you need to have SQL installed prior to setting up SCOM. I am planning to use SQL 2016 and noticed above that you were going to add a guide with instructions for SQL 2016. Are you any closer to releasing this as it would be very useful to use as a guideline as the rest of your post is very good?

    Thanks.

    Like

      1. Thank you for the prompt reply Ravi. I have just seen your SQL 2016 guide attached. I appreciate you posting it sooner than anticipated. I’ll proceed with the build and let you know how it goes.

        ps – The script for the automated accounts for SCOM looks awesome so I’ll be trying that out as well 🙂

        Like

  2. Powershell script create a account SCOM_OMS….why this account being created in script as it seems not used in the setup ?

    Like

  3. Thanks for the great guide. When running the setup the option to select Management sever is not selectable (grayed out). Any ideas?

    Like

      1. Thanks for the quick response. The server had a 2012 SCOM agent installed. Once removed. It allowed me to select Management server.

        Like

  4. Ran into another issue. I installed a default SQL 2016 instance on my management server, however when running through the setup it does not show up as an option when prompted to select the SQL server instance for reporting services. The list is blank. Any ideas?

    Like

    1. Hi Tom, Was SSRS installed during the SQL instance install? Did you select the option to install only, or install and configure? I would advise, go into SSRS and re-configure the setup. Then try running the SCOM install again.

      Like

      1. Hi Ravi, SSRS was not installed, after installing it, the server shows up as an option. Now there’s an error that it’s configured incorrectly. I’m in the Reporting services configuration manager. Do you know what needs to be done to get past the error?

        Like

  5. The error is “The specified SQL Server instance is not valid.
    *SSRS has not been configured correctly
    *SSL is configured for the SQL server Report Server
    *A proxy server is configured for the SQL Server Report Server

    Like

      1. Yes thanks, I finally got past the SSRS errors however SCOM still fails during the install phase. The install appears to be much more complicated than I expected. I think it may be due to the SQL server configuration. Is there a reason you’re using two instances?

        Like

      2. Typically in production environments, I suggest to my customers to have the SCOM OpsDB and DW (Data Warehouse) on separate instances and also on separate servers. This is due to the IPOS and workloads the DW commands. If you choose, you can always install both DBs on on server and a single instance.

        Like

  6. Hi. I didn’t see where in the SQL install that you installed reporting services. When should that be done, and to which instance, or both instances? The screenshot above where you select instance for SSRS to instance SCOM2016, I didn’t see that created in your documentation. Please advise. I want to install SCOM and SQL (both 2016). I want to use the same server for both in dev, and have separate servers for prod.

    Thanks,
    Mick

    Like

    1. Hi Mick, that is odd, the SQL 2016 install link may have been broken on the post. I have fixed that now. Nevertheless, the answer to your question. In most environments I would deploy a dedicated SQL instance for SCOM Reporting. But you can always install SSRS along the OperationsManager database instance and/or OpsMgr Data Warehouse instance. Once you have made that decision and configured SSRS, you can select the Reporting features to be deployed on a specific instance then. I hope that helps.

      Like

  7. hello I have problem in the “SQL Server instance for reporting services” screen
    SQL server instance does not show me any instance to select.

    Knowing that:
    I installed sql with a named instance
    I added the native “feature” reporting.
    I have configured TCP port 1433 for all sql services.
    I have disabled the firewall at both the database server and scom.
    I have disabled the proxy server at both the database server and scom.
    I checked with telent the 1433 and 80 port. it seems good.

    I added the url http: // scomdb / Reports_INSTANCESCOM / (scombd = server hostename) & (INSTANCESCOM = instance name)

    Like

  8. Hi,

    I’m new in System Center and I need to install/configure Operation Manager, Configuration Manager and Virtual Machine Manager. Is there a recommended installation order or can I handle it as 3 separate installations?

    Like

    1. Hi Alex, in enterprise environments, I would highly suggest this is not the best practice approach. Not only will it hinder your performance (IPOS is one of them) for each application, but the potential of data loss would affect 3 applications. Thus, I would suggest having all three applications a dedicated server, and dedicated SQL server/instances. Please see Microsoft’s article on the system requirements for System Center 2016: https://docs.microsoft.com/en-us/system-center/scom/plan-system-requirements

      Like

  9. I am curious why is there SQL Service Reporting Services Account? I couldn’t find it mentioned on any other guide including technet, and usually SCOM SQL Reader account is used for Reporting Services. On Technet, under Data Reader account is says that it has to have this assignment:
    Applications: Windows service Database/Role: SQL Server Reporting Services Role/Account: Logon account
    https://docs.microsoft.com/en-us/system-center/scom/plan-security-accounts

    Please correct me if I’m wrong.

    Like

  10. Hi, I have found your guides very helpful. Thank you for providing them!

    I have a few issues with my current SCOM 2016 and SQL 2016 Configuration.

    – I can’t get Notifications to be sent despite creating a Channel, Subscriber, Subscription, and a Run As Configuration Account. I don’t have an on premise exchange server. My environment is all Office 365 cloud based and AD synced. I believe theirs suppose to be a Monitoring Host service but I don’t see it at all in my SCOM management servers services.

    – My SSRS does work but as I keep clicking through it on IE I eventually get “An error has occured during report processing. (rsProcessingAborted) Cannot create a connection to data source ‘DataWarehouseMain’. (rsErrorOpeningConnection). A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)
    My reporting url does display a dash in it “-” or a space then a dash then the forward slash.

    ( I have installed Server 2016, SCOM 2016, SQL 2016, SSRS all on 1 server)

    Like

      1. Thanks Ravi, Here is my feedback:

        Issue #1 – We do have a relay server already with a virtual server configured. I don’t know how to get SCOM notifications going with an smtp relay server already configured. I’ve tried but havn’t gotten it quite right.

        Issue #2 – I get the same error on any browser. I can get to servername/reportserver – / page but when I try to click on a Microsoft.SystemCenter.DataWarehouse.Report.Library report like Microsoft.SystemCenter.DataWarehouse.Report.Alert I get the error

        “An error has occured during report processing. (rsProcessingAborted) Cannot create a connection to data source ‘DataWarehouseMain’. (rsErrorOpeningConnection). A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)

        Like

  11. Hi Ravi,

    I was able to get notifications working and generating to email. Thanks for the information and assistance.

    Now I’m looking to exclude some servers from creating a notification by email. I want to do this with test servers where they generate a SCOM Alert but not a email notification. I’ve made several groups to test and modified the criteria in the subscription I already have been using but so far creating a custom group hasn’t worked.

    When I use create a group, then adjust the criteria in the Subscription to use that group no notification to email is created. When I take the group out of the subscription criteria then email notifications work.

    Any thoughts?

    Like

    1. Hi Nick,

      I am not too sure if I follow. What is the ask, are you trying to have a group where its alerts are only generated in the SCOM console, and no SMTP alerts are sent?

      Like

  12. Hi Ravi – Excellent notes.

    I followed and installed 2 instances (SCOM_OPSMGR and SCOM_DW). During the install, I selected Reporting Services Native (install and configure for both the instances). Logged into SSRS and I see both the instances and two reporting services database. My question is do, I configure SSRS for both the instances or just for one?

    Like

    1. Hello, you only need SSRS for one of the instances. Reporting can be installed in either instance, I typically install on the OpsMgr, as the hit to SSRS is minimal. You can always install SSRS on the default instance, or create a dedicated instance for SSRS, but that is a bit much.

      Like

  13. Can SSRS database share the same instance as OpsMgr in 2016 SQL Svr Standard with Availability Group configuration? And what is the best practice?

    Like

    1. Yes, you can run SSRS on the same instance has the Ops DB. Typically SSRS is not a high priority, so there is no best practice around that. However if you want to achieve HA for SSRS, then deploying a DAG or Always-On is best.

      Like

  14. and i thought installing SQLServer is hard. 😉
    Question, is it advisable to separate the database from scom server? like have a sqlserver server and a scom server or install both in the same server?

    Like

    1. for production environments, and even dev labs, always separate the workloads. dedicated SCOM management server, and a dedicated SQL instance. if you can, have a dedicated SQL instance for Ops Mgr and DW. and ideally mirror dev with production.

      Like

  15. Hi Ravi,
    Thank you for all you do on this site!

    We are getting a brand new SCOM 2016 server installed to monitor only 50-60 server devices, a few SCCM & DP’s, exchange, Unix/Linux servers and the rest print servers, db, app servers located mainly at the home base with a few servers spread out over 6 states here in the Southern part of the US.
    My question is could we get away with only running 1 VM server with 8 cores & 16gb ram loaded with Server 2016 x64 DataCenter & SCOM 2016 RU5 and/or should I have another MS server for running ACS? Can we configure the SCOM DB and WDB running local on this same server considering it’s only for monitoring a few servers? Also is SQL Express to install ok or do we need to purchase a SQL license? How many servers all together should we dedicate for SCOM?

    Thank you in advance,
    Robbie

    Like

    1. Hi Robbie,

      I think you can get away with having just the 1 server supporting your SCOM management server that is also running ACS. For more details see the system requirements from Microsoft here, https://docs.microsoft.com/en-us/system-center/scom/system-requirements?view=sc-om-2019.

      Depending on your resources, you can get away with having the Ops DB and DW on the same server. I would recommend having two different instances for the DBs. Since the number of servers is low, this should be fine. You could probably get away with having both databases on 1 single instances since the IOPS could be relatively low.

      Lastly, for running SQL Express, I don’t think this is a support option. I am pretty confident you need to go with at least Standard SQL. Enterprise if you plan to do Always-On. For more guidance around SQL/SCOM requirements, see here, https://docs.microsoft.com/en-us/system-center/scom/plan-sqlserver-design?view=sc-om-1711#sql-server-requirements.

      Like

    1. Hello, but the other options are there? did it pass the prerequisites? does the server already have the Microsoft Monitoring Agent installed? I suspect the ladder is the case, and you will need to remove the MMA then proceed with the install.

      Like

  16. Here is a quick question. SCOM 2016 says that to install it, you need Active Directory directory services (Which actually should say Domain Services, not directory services) but, when installing it on a ADDS machine, it says it’s now recommended to install it on a domain controller but, you can install it anyways.

    What would you recommend ?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.