Chat now with support
Chat with Support

Identity Manager 9.3 - Release Notes

Supported database systems

One Identity Manager supports the following database systems:

  • SQL Server

  • Managed instances in the Azure SQL Database

  • Azure SQL Database

  • Amazon RDS for SQL Server

Minimum system requirements for implementing SQL Servers as database servers

Minimum system requirements for implementing SQL Servers as database servers

A server must meet the following system requirements for installation of a One Identity Manager database. Depending on the number of One Identity Manager modules and the accounts managed in One Identity Manager, the requirements for working memory, hard disk storage, and processors may be significantly greater than the minimum requirements.

Table 21: Minimum system requirements for SQL Servers

Requirement

Detail

Processor

8 physical cores with 2.5 GHz+ frequency (non-production)

16 physical cores with 2.5 GHz+ frequency (production)

NOTE: 16 physical cores are recommended on the grounds of performance.

Memory

16 GB+ RAM (non-production)

64 GB+ RAM (production)

Hard drive storage

100 GB

Operating system

Windows operating system

  • Note the requirements from Microsoft for the SQL Server version installed.

UNIX and Linux operating systems

  • Note the minimum requirements given by the operating system manufacturer for SQL Server databases.

Software

Following versions are supported:

  • SQL Server 2022 Standard Edition (64-bit) with the latest cumulative update

NOTE: For performance reasons, the use of SQL Server Enterprise Edition is recommended for live systems.

NOTE: Ledger is not supported. For more information, see the Knowledge Base.

  • Compatibility level for databases: SQL Server 2022 (160)

  • Default collation: case insensitive, SQL_Latin1_General_CP1_CI_AS (recommended)

  • SQL Server Management Studio (recommended)

NOTE: The minimum requirements listed above are for general use. With each custom One Identity Manager deployment these values may need to be increased to provide ideal performance. To determine production hardware requirements, it is strongly recommended to consult a qualified One Identity Partner or the One Identity Professional Services team. Failure to do so may result in poor database performance.

For additional hardware recommendations, read the KB article https://support.oneidentity.com/identity-manager/kb/290330/how-to-configure-settings-as-per-the-system-information-overview, which outlines the System Information Overview available within One Identity Manager.

NOTE: In virtual environments, you must ensure that the VM host provides performance and resources to the database server according to system requirements. Ideally, resource assignments for the database server are fixed. Furthermore, optimal I/O performance must be provided, in particular for the database server. For more information about environment virtualization, see One Identity's Product Support Policies.

Requirements for a managed instance in Azure SQL Database

Requirements for a managed instance in Azure SQL Database

For more information about Azure SQL Database, refer to the Microsoft website under https://azure.microsoft.com/en-us/products/azure-sql/database/.

The following requirements and limitations apply to the use of a managed instance in Azure SQL Database as a database system.

  • The Business Critical tier is required.

  • Ledger is not supported. For more information, see the Knowledge Base.

Requirements for Azure SQL Database as database system

Requirements for Azure SQL Database as database system

For more information about Azure SQL Database, refer to the Microsoft website under https://azure.microsoft.com/en-us/products/azure-sql/database/.

The following requirements and limitations apply to the use of Azure SQL Database as a database system.

  • If you use Azure SQL Database as the database system, you must supply a database. There is no support for creating a new database in Azure SQL Database with the Configuration Wizard.

  • use statements are not supported.

  • Strong passwords must be used for the SQL login.

    For more information, see under Strong Passwords in the Microsoft documentation.

  • Ledger is not supported. For more information, see the Knowledge Base.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating