Supported SQL Servers

ePO - On-prem software requires the use of a supported SQL Server.

ePO - On-prem supports any edition of these Microsoft SQL Server versions.

Microsoft SQL Server 2014
Microsoft SQL Server 2016
Microsoft SQL Server 2017
Microsoft SQL Server 2019
Microsoft SQL Server 2022
Microsoft SQL Server 2025

Note
ePO - On-prem also supports Amazon RDS for SQL Server which allows you to deploy SQL Server in the cloud. https://aws.amazon.com/rds/sqlserver/

Required SQL Server configuration settings

ePO - On-prem software requires some specific SQL Server configuration settings. For information about working with these settings, see your SQL Server documentation.

Configuration	Details
Nested triggers	The SQL Server Nested Triggers option must be enabled.
Database collation	ePO - On-prem software supports all Microsoft SQL Server collations using the following two SQL collation properties: Case Insensitivity (CI) Full ASCII character set support (these characters are included in all Unicode-based character sets) To view the supported Microsoft SQL Server collation types, see KB73717.
Maintenance settings	We recommend making specific maintenance settings to ePO - On-prem databases. For instructions, see the product guide for ePO - On-prem.

Configuration

Details

Nested triggers

The SQL Server Nested Triggers option must be enabled.

Database collation

ePO - On-prem software supports all Microsoft SQL Server collations using the following two SQL collation properties:

Case Insensitivity (CI)
Full ASCII character set support (these characters are included in all Unicode-based character sets)

To view the supported Microsoft SQL Server collation types, see KB73717.

Maintenance settings

We recommend making specific maintenance settings to ePO - On-prem databases. For instructions, see the product guide for ePO - On-prem.