after some work problems I get back to new SCOM 2016 installation. I mentioned last time that we will today install SQL server. There were some questions about which version to use. I wanted to install SQL 2016 SP1 but I get notice it is not yet supported (see comments on this post by Kevin Holman. You can get the list of last supported databases with SCOM 2016 UR1 on this TechNet link
You can use version you choose, because if you remember SQL license is free for System Center products. With only one rule, just use it for System Center products databases and nothing else.
Did you create SQL service account. If you didn’t, do it now. I created only two. One for SQL service account and one for SQL Reporting services account. So lets start. Choose new SQL server installation
If everything is green you are good even windows firewall scream for attention here. You choose next features needed for SCOM SQL installation
Choose default instance if you don’t need better that that
Enter you domain service accounts for SQL services and give services automatic startup. Also check Volume Maintenance Task privilege to use this new SQL feature.
You need to use this SQL collation. In any case it is by default in SQL installation sou you will not miss it
Specify Windows authentication mode (do not use Mixed mode)
You setup your database and log files as you can, but rule of the thumb is to format those drives with 64K allocation unit sizes, and if you have possibility put your tempdb database and log on SSD drive. It is best to leave that volumes only for databases.
On Reporting Services page choose Install and Configure
Click next on Feature Configuration Page if everything is green and then Install on Ready to Install page.
After everything is done, we are free to go further. Until next time