The following is a guide on how to install SQL 2016 for your System Center Operations Manager (SCOM) 2016 environment. I will be installing SQL 2016 on a brand-new server with Windows Server 2016 installed.
To begin, I am going to set the following accounts as a Local Administrator on the server. Also, I am going to be creating two SQL instances, one for the Operations database, and the other for the Data Warehouse. Since this is for my personal lab, I am not dedicated storage/drives for the databases.
|domain\SCOM_AA||SCOM Action Account|
|domain\SCOM_DA||SCOM Data Access/SDK Account|
|domain\SCOM_SQL_READ||SCOM SQL Reader|
|domain\SCOM_SQL_WRITE||SCOM SQL Writer|
|domain\SQL_SA||SQL Service Account|
Next, let’s run the setup wizard as the SQL_SA account to make life easier down the road…
For the complete post, please visit SCOMandOtherGeekyStuff.com.