Configuring Amazon RDS MSSQL as the Backend Database

PAM360, by default, comes bundled with PostgreSQL as the backend database. However, PAM360 allows you to configure different databases to cater to your needs. In addition to configuring various databases, PAM360 allows you to migrate all your data from your local MS SQL database to the Amazon RDS MS SQL database.

This document explains in detail the steps to configure Amazon RDS MS SQL, an on-demanding service in the backend database.

Steps Required

  1. Download and install PAM360 in a AWS EC2 instance.
  2. Create an RDS MSSQL database in AWS.
  3. Now, rename the below files under PAM360\conf directory:
    • wrapper.conf to wrapper.conf_old
    • wrapper_lin.conf to wrapper_lin.conf_old
    • wrapper_lin.conf to wrapper_lin.conf_old
    • wrapper_lin.conf_mssql to wrapper_lin.conf
    • pam360_key.key to pam360_key.key_old
    • database_params.conf to database_params.conf_old
    • customer-config.xml to customer-config.xml_old
    • customer-config.xml_mssql to customer-config.xml
  4. Download and replace the below files under PAM360\conf directory.
    • customer-config.xml
    • database_params.conf
    • masterkey.key
  5. Open masterkey.key file and enter a new password.
  6. Open SQL studio and execute the following query:

     use <DBNAME>;

    create master key encryption by password = 'Password entered in the masterkey.key file';

  7. Open database_param.conf file.
    • Replace <%DNS_NAME%> with MS SQL instance name.
    • Replace <database name> with the encrypted database name.
    • Replace Username and Password.
    • change.db.password.encrypted=false
  8. Download MS SQL root CA.
  9. Import a .pem file into PAM360 using the following command:
    1. Open command prompt and navigate to <PAM360_Home>\jre\bin.
    2. Execute the following command:

      'keytool.exe -import -v -alias <alias name> -file <certificate path> -keystore  ..\lib\security\cacerts -keypass changeit -storepass changeit -noprompt'

    Now, you have successfully configured Amazon RDS MSSQL as the backend database.
Top