Configuring a secure connection to the Microsoft SQL Server database server
You can configure a secure connection to encrypt transactions between the IBM® Sterling Control Center Monitor engine and Microsoft SQL Server 2016 Enterprise Edition or Microsoft SQL Server 2019 Enterprise Edition database instances. You can configure the secure connection in either a high availability or non-high availability environment.
- Before you configure IBM Sterling Control Center
enable secure connections to the databases, complete the following tasks for the Microsoft SQL
Server database server:
- Create a self-signed certificate (trusted database server certificate).
- Install a certificate in the Microsoft Windows certificate store of the server computer.
- Configure SQL Server to use this certificate using the SQL Server Configuration Manager.
- Export the self-signed certificate.
- Create and configure the keystore and truststore files in IBM Sterling Control Center Monitor.
- Install IBM Sterling Control Center Monitor.
- During the Microsoft Windows installation, select Microsoft SQL Server as the database type and provide information about the Microsoft SQL Server database.
- Import the trusted database server certificate you exported during the MS SQL database server set up into the IBM Sterling Control Center Monitor engine truststore.
- Use one of the following methods to run the configCC utility:
Microsoft Windows UNIX Double-click configCC.bat in installation directory\bin. Run the configCC.sh utility from installation directory/bin.
- When you are prompted to secure the connection to each of the IBM Sterling Control Center Monitor databases (production and staging), type Y.
- Type Y to confirm your configuration changes.