SQL Server ports – The Intersite communications use the SQL Server Service Broker, which uses port TCP 4022 by default.Take a look at SQL Server Memory Configurations.SCCM requires Windows authentication to validate connections to the database.Only the Database Engine Services feature is required for each site server.While installing SQL server, the site database must use the following Database collation: SQL_Latin1_General_CP1_CI_AS.Configuration Manager requires a 64-bit version of SQL Server to host the site database.Listing some of the important configurations required for all SQL server installs. It should be on the site server computer. However the SQL Server cannot be remote in this case. The SQL server can be on site server computer or it could be on a remote computer.įor secondary sites, the site DB can use default instance of a full install of SQL Server, or SQL Server Express. When you install SQL for CAS and Primary sites, site database always uses full install of SQL. If you are looking at size and scale numbers for System Center Configuration Manager click this link.

This will help you out in choosing the SQL server during configuration manager install or upgrade. In this post I will list the SQL versions supported for SCCM current branch.

One important aspect during the SCCM upgrade is to know the supported SQL server version. With the release of SCCM 1606 a lot of organizations are planning to upgrade their configuration manager environment. This SQL server version should be supported by configuration manager. When you install SCCM, you require SQL server to host the site database. In this post, we will look at the supported SQL server versions for SCCM current branch.

Sql server enterprise manager