When Azure SQL is used for the CMDB database, tables and users must be created before the CM server is installed.
Install the Azure SQL database according to the instructions for the downloaded Azure SQL installation package. Name the database instance 'cmdb'. It is recommended to create the database in the same region and to include it to the same virtual network as the virtual machines that will be running CF.
Extract the Azure SQL database scripts create_user.sql and create_cmdb.sql, located at program_files/install/AzureSQL, from the server installation zip file, cm_server_<version>.zip.
Step-by-step instruction
Change the password for the lcmreq user, that will be created by the script below. The default password is REQreq01.
Login as a user with administrative rights. It will be used to execute the scripts.
On the master database, run the script that creates the lcmreq login:
create_login.sql
Check the log file and verify that the script was successful.
On the CMDB database, run the script for creating the CMDB tables:
create_cmdb.sql
Check the log file and verify that the script was successful.
When installing the CM server, include the SQLServer JDBC component to create the database connection parameters, which are stored in the cm.confconfiguration file.
TLS is enforced on the server side by default on Azure SQL databases.
The parameters for the JDBC connection URL that is created in the cm.conf configuration file during the CM installation, is going to work with the Azure SQL database.
The driver will initiate the TLS certificate exchange.