Document toolboxDocument toolbox

Nexus Documentation
CURL vulnerability information (CVE-2023-38545) - Nexus awareness advisory on Microsoft's update KB5014754

Set up Microsoft SQL server in Certificate Manager using Podman

Owned by Ylva Andersson
Last updated: Jul 11, 2024Version comment
1 min read

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.

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

  1. 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

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

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

Copyright 2024 Technology Nexus Secured Business Solutions AB. All rights reserved.
Contact Nexus | https://www.nexusgroup.com | Disclaimer | Terms & Conditions