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

For detailed information about how to install Azure SQL, see the documentation available at https://azure.microsoft.com/en-us/products/azure-sql/database/.

Prerequisites

• Install the Azure SQL database according to the instructions for the downloaded Azure SQL installation package.

• Extract the Azure SQL database scripts create_login.sql, create_cmdb.sql, add_bootca.sql, located at certificate-manager-8.X.Y-Z.zip\cmdb-install-tool-8.X.Y.zip\install\AzureSQL, from the server containerization zip file.

Step-by-step instruction

Edit settings on the Azure SQL server

1. Change the password for the lcmreq user, that will be created by the script below. The default password is REQreq01.

2. Login as a user with administrative rights. It will be used to execute the scripts.

3. On the master database, run the script that creates the lcmreq login:

   create_login.sql

4. Check the log file and verify that the script was successful.

5. On the CMDB database, run the script for creating the CMDB tables:

   create_cmdb.sql

6. Check the log file and verify that the script was successful.

7. On the CMDB database, Run the script for adding the bootca: > add_bootca.sql

8. Check the log file.

Edit settings on the CM server

Navigate to the volume hosting the cm server config directory and update the database parameters in cm.conf

• Database.name

• Database.user

• Database.password

Secure the connection

See Set up Azure SQL in Certificate Manager.