Part III: Installing the Site Database

We have decided to install the Site Database on the Site Server.
This will reduce the number of devices that can be managed by the system, but in my estimate, this should be sufficient.

The installation of the SQL server is fairly simpel.
I install the program to c:\program files and changes the database files and log files to dedicated drives.
For SCCM it is only needed to install:
- Database Engine Service
- SQL Server Reporting Services
- Management Tools
A very important thing to remember: Install with the correct collation -  SQL_Latin1_General_CP1_CI_AS

I will use a domain account to run the services..
- then we shall remember SetSPN
- - setspn –A MSSQLSvc/SQL Sever netBIOS name:1433 domain\account
- - setspn -A MSSQLSvc/SQL Sever FQDN:1433 domain\account
-- you can verify by: setspn -L domain\account

SQL Server memory will have to be configured.
-- min 8GB for the SQL server
-- max (leave at least 4 GB for OS and applications)

Remember to configure the Firewall to allow traffic on TCP 1433 and TCP 4022 (this is for SQL replication)

Additional task:
Since the box has 16 cores, after installation of SCCM I will configure 16 database files for th CM database.

But now I will be ready to install WSUS.