Easy2Patch v4.0
Easy2Patch v4.0
  • Infrastructure Documents
  • Overview
    • What is Easy2Patch?
    • Request a new 3rd Party Applications
    • FAQs
    • Road Map
    • Release Notes
    • Version Compare
    • Licensing
  • Planning
    • POC Requirements for Easy2Patch 3.1
    • POC Requirements for Easy2Patch 4.0 Web Edition
    • Supported Configurations
    • Windows Operating System Requirements
    • SQL Server Requirements
    • Other Requirements
    • Network Considerations
    • Antivirus Exclusion List for Easy2PatchV3
    • Design
      • Update & Application & Intune (Server Deployment)
      • Standalone WSUS Deployment
      • Standalone Intune Deployment
  • Deployment
    • Installing WSUS Console
    • Installing SCCM Admin Console
    • Installing IIS Component for Easy2Patch 4.0
    • Configuring Intune Application Registration
    • Getting Code-Signing Certificate
    • Installing Easy2Patch 3.1
      • Upgrading to Easy2Patch 3.1.10
      • Licensing Easy2Patch 3.1
    • Installing Easy2Patch 4.0
      • Upgrading Easy2Patch 4.0
      • Easy2Patch Backup & Restore
      • Licensing Easy2Patch 4.0
  • Configuring
    • SSL Configuration in WSUS for 3rd Party Update
    • Configuring ConfigMgr for 3rd Party Updates
    • Easy2Patch 3.1 Settings
      • General
        • Certificate Management
        • Backup Settings
          • Restore Easy2Patch 3.x
        • General Settings
        • Application Deployment
        • Intune Deployment
        • Maintenance
      • Notification
        • E-Mail
        • Telegram
          • Creating a Telegram Bot
          • Telegram Chat ID
      • SCCM / WSUS / INTUNE
        • WSUS Settings
        • SCCM Settings
        • Database Settings
        • Intune Settings
      • Proxy
    • Easy2Patch 4.0 Settings
      • Migrate from Easy2Patch 3.x
      • General Settings
        • General
        • Identity
          • Active Directory
          • EntraID
            • Required Permissions for EntraID
        • Proxy
        • Log
        • Maintenance
        • Login
      • Deployment Settings
        • Process Conflict
        • Update
        • Application Deployment
        • Intune Deployment
        • Defender
      • Connection Settings
        • Database
        • SCCM
        • WSUS
        • Intune
      • Managements
        • Role
        • License
        • Certificate Management
      • Alert Settings
        • Notification
          • E-Mail
          • Telegram
            • Creating a Telegram Bot
            • Telegram Chat ID
            • Telegram Setting
        • Alerts
        • Recipients
  • Managing Easy2Patch
    • Easy2Patch 3.1
      • Update
      • Application Deployment
      • Intune Update
      • Intune Application
      • License Management
    • Easy2Patch 4.0
      • Dashboard
        • WSUS
        • SCCM
        • Intune
      • Update
        • Application Custom Settings
        • WSUS Maintenance
        • Side Menu
      • Application
        • Application Deployment Right Click Menu
        • Application Custom Settings
        • SCCM Maintenance
        • Side Menu
      • Intune Update
        • Intune Update Right Click Menu
        • Application Custom Settings
        • Intune Maintenance
        • Side Menu
      • Intune Application
        • Intune Application Right Click Menu
        • Application Custom Settings
        • Intune Maintenance
        • Side Menu
      • CVE List
      • Schedule
      • Reporting
        • Update Status
  • Troubleshooting
    • Schema files not found!
    • Failed to sign package
    • Fixing 500.19 web.config error
    • Securing Windows Server
Powered by GitBook
On this page
  • Supported versions of SQL Server
  • SQL Server architecture version
  • Database collation
  • Database compatibility level

Was this helpful?

  1. Planning

SQL Server Requirements

Easy2Patch 4.0

PreviousWindows Operating System RequirementsNextOther Requirements

Last updated 11 months ago

Was this helpful?

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 . 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

Microsoft Lifecycle Policy