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
Monitor to
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.
About this task
Use this procedure to enable encryption and SSL authentication between the IBM Sterling Control Center
Monitor engine and Microsoft SQL Server
databases. To configure a secure connection between the IBM Sterling Control Center
Monitor engine and Microsoft SQL Server
databases in a high availability or non-high availability environment:
- 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.