Database Requirements
Directory Manager requires an SQL Server database to store and retrieve data. The SQL database may reside on any SQL Server in your environment.
Directory Manager supports the following versions of SQL Servers:
| Database Servers | Editions |
|---|---|
| Microsoft SQL Server 2016 | Express, Standard, Enterprise Express edition available at: SQL Server 2016 Express edition |
| Microsoft SQL Server 2017 | Express, Standard, Enterprise Express edition available at: SQL Server 2017 Express edition |
| Microsoft SQL Server 2019 | Express, Standard, Enterprise Express edition available at: SQL Server 2019 Express edition |
| Microsoft SQL Server 2022 | Express, Standard, Enterprise Express edition available at: SQL Server 2022 Express edition |
The SQL Server Browser service is required and during the installation of SQL Server, you can set its start mode either as Automatic, Disabled or Manual. If it is disabled, SQL Servers are not listed in the SQL Server box on the Database settings page of the Configuration Tool. In that case, you have to type the server name in the SQL Server box to select the required server manually.
To enable the SQL Server Browser service, see How to: Start and Stop the SQL Server Browser Service.
NOTE: Directory Manager now uses .NetCore 8 and it requires a SQL certificate to access database using Windows Authentication. Therefore, if you want to access the Directory Manager database using Windows Authentication, then a SQL certificate must be added to the Trusted Root Certification Authorities certificate store on connecting clients or servers such as Directory Manager. See the SQL Certificate for Windows Authentication topic for additional information.