SQL Server Requirements

Easy2Patch 4.0

Easy2Patch 4.0 environment requires a supported SQL Server version and configuration to host the Easy2Patch database.

SQL Server can be located on:

• Configuration Manager Database server computer,

• A server that is remote or local that Easy2Patch will be install,

The following instances are supported:

• The default or named instance of SQL Server,

• A SQL Server Always On failover cluster instance,

• A SQL Server Always On Availability Group.

The database required for Easy2Patch can be hosted on SCCM's database server.

If this server will not be used, Easy2Patch can be used by establishing a separate instance. In this case, SQL Server 2022 Express edition is sufficient for Easy2Patch to run.

Supported versions of SQL Server

In a hierarchy, Easy2Patch server access the SQL Server database:

• The SQL Server versions you use remain in support by Microsoft.

• For SQL Server 2016 and prior, support for each SQL Server version and service pack follows the Microsoft Lifecycle Policy. Support for a specific SQL Server service pack includes cumulative updates unless they break backward compatibility to the base service pack version

SQL Server 2022: Standard, Enterprise or Express. You can use this version with latest cumulative update, as long as your cumulative update version is supported by the SQL Server lifecycle. RTM version is the minimum requirement for SQL Server 2022.

SQL Server 2019: Standard, Enterprise or Express. You can use this version with cumulative update 5 (CU5) or later, as long as your cumulative update version is supported by the SQL Server lifecycle. CU5 is the minimum requirement for SQL Server 2019 as it resolves an issue with scalar UDF inlining.

SQL Server 2017: Standard, Enterprise or Express. You can use this version with cumulative update version 2 or higher, as long as your cumulative update version is supported by the SQL Server lifecycle.

SQL Server 2016: Standard, Enterprise or Express. You can use this version with the minimum service pack and cumulative update supported by the SQL Server lifecycle.

SQL Server 2014: Standard, Enterprise or Express. You can use this version with the minimum service pack and cumulative update supported by the SQL Server lifecycle.

SQL Server architecture version

Easy2Patch requires a 64-bit version of SQL Server to host the site database.

Database collation

SQL Server that's used for the database must use the following collation: SQL_Latin1_General_CP1_CI_AS.

Database compatibility level

The following table identifies the recommended compatibility levels for Easy2Patch databases:

SQL Server version	Supported compatibility levels	Recommended level
SQL Server 2014	120	120
SQL Server 2016	130, 120	130
SQL Server 2017	140, 130, 120	140
SQL Server 2019	150, 140, 130, 120	150
SQL Server 2022	160, 150, 140, 130, 120	160