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