SQL Server 2019 Collation for ConfigMgr.

What are the Supported SQL Server Versions for ConfigMgr.

You can install SQL Server 2019 for the following SCCM sites :.

Always install the latest available cumulative update. While with SQL 2017, you have to configure the memory limits manually.Ĭumulative Update CU5 is the minimum requirement for SQL Server 2019 as it resolves an issue with scalar UDF inlining. However SQL Server 2019 setup includes the options to define or configure memory limit configurations for SCCM. I would also like to mention that SQL Server 2017 and SQL Server 2019 installation is similar. Until Microsoft tests and confirms the supported SQL Server version for ConfigMgr, do not install it or upgrade your SQL in production. You then perform in-place upgrade of SQL Server.

Now it’s true that you install SQL server only once for ConfigMgr. SQL 2019 is the latest version as of today and it is supported by ConfigMgr 1910 and above.Įach Microsoft Endpoint Configuration Manager site requires a supported SQL Server version and configuration to host the site database. With every new release of SQL server you get performance benefits, new features and a faster experience.

When I build my ConfigMgr lab, I always prefer to install the latest supported SQL server version. The SQL Server 2019 is a supported SQL server version for ConfigMgr 1910 and above. This post is a step-by-step guide to install SQL Server 2019 for ConfigMgr.

Installing sccm