Configuring an application server to enable an encrypted connection with SQL database

Before you enable an encrypted connection on an SQL database, you must configure your TrueSight Server Automation and BMC Decision Support for Server Automation or TrueSight Smart Reporting for Server Automation application servers, as follows:

  1. Navigate to the following paths on your BSA or BDSSA application servers:

    TrueSight Server Automation Application Server

    <TSSA_ApplicationServer_Installation_Directory>\BMC Software\appserver\jre\lib\security

    TrueSight Smart Reporting for Server Automation Application Server

    <SmartReportingforServerAutomation_Installation_Directory>\BMC Software\BDSSA\jre\lib\security

  2. Run the following command:
    keytool -import -v -trustcacerts -alias <Database_Server> -file <path_to_public_key_certificate> -keystore cacerts

    Replace the variables in the command with the following information:

    • <Database_Server> is the host name or IP address of the SQL database server
    • <path_to_public_key_certificate> is the path to the public key CA certificate

 


 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*