Set up Microsoft SQL server in Certificate Manager using Podman

This article is new for Certificate Manager 8.10.4.

This article describes how to install and set up the MSSQL database, used in Smart ID Certificate Manager (CM), using Podman.

For detailed information about how to install MSSQL, see the documentation available at https://www.mysql.com/.

Prerequisites

• The hardware requirements for MSSQL Server specified by Microsoft, applies for the database machine

• The CM Podman distribution has been downloaded from the Nexus Support download

Step-by-step instruction

1. Install Microsoft SQL Server according to the instructions in Set up Microsoft SQL server in Certificate Manager.

2. Define transaction log size according to the instructions in Set up Microsoft SQL server in Certificate Manager.

3. Install CMDB tables etc.

   1. Unzip the contents of the CM Podman distribution "certificate-manager-8.10.4-1.zip"

   2. Unzip the contents of cmdb-install-tool-8.10.4.zip

   3. Open the folder install/MSSQLServer

   4. Run the provided sql scripts against your Microsoft SQL Server installation in the following order:

      1. create_cmdb.sql

      2. add_bootca.sql

4. Secure the connection according to the instructions in Set up Microsoft SQL server in Certificate Manager.

5. Set up log in using Windows authentication according to the instructions in Set up Microsoft SQL server in Certificate Manager.