Starting with SQL Server 2017, service packs won't be released since it follows a modern servicing model. Support for a specific SQL Server service pack includes cumulative updates unless they break backward compatibility to the base service pack version. For more information, see SQL Server replication backward compatibility.įor SQL Server 2016 and prior, support for each SQL Server version and service pack follows the Microsoft Lifecycle Policy. SQL Server supports replication between the two versions of SQL Server.The SQL Server versions you use remain in support by Microsoft.Configuration Manager supports the versions of SQL Server that you use.In a hierarchy with multiple sites, different sites can use different versions of SQL Server to host the site database.

SQL Server transactional replication is supported only for replicating objects to management points that are configured to use database replicas. SQL Server database mirroring technology, and peer-to-peer replication The following configurations aren't supported:Ī failover cluster instance in a Network Load Balancing (NLB) cluster configurationĪ failover cluster instance on a Cluster Shared Volume (CSV) SQL Server must be located on the site server computer. The site database can use the default instance of a full installation of SQL Server or SQL Server Express. For more information, see Prepare to use a SQL Server Always On availability group. For more information, see Use a SQL Server Always On failover cluster instance for the site database.Ī SQL Server Always On availability group. The default or named instance of SQL Server.Ī SQL Server Always On failover cluster instance. A computer that is remote from the site server.The site database must use a full installation of SQL Server. SQL Server instances and locations Central administration site and primary sites

Applies to: Configuration Manager (current branch)Įach Configuration Manager site requires a supported SQL Server version and configuration to host the site database.

Spn for scom 2016