DB Connection Manager Utility

During the intallation, Qommentary will encrypt database parameters into a connection string which is stored in the Qommentary Engine settings file.

The DBConnection Manager Utility allows you to decrypt, update and encrypt the database connection string in you need to update the database hostaname, username or password.

To update the connection string, please follow these steps:

1. Download the DB Connection Manager Utility 2. Unzip contents to any folder of your choice 3. Run the Qommentary.DBConnectionManager.exe file 4. Copy the encrypted connection string from the appsettings.json file located on the Qommentary Engine folder

"ConnectionStrings": {
"Qommentary": "zKA40nbrJzFIzu1kXecgP45n1d1f9beA6MBvieX99UUmFMQxc2lpem8x6hV+TNDjgOa3+lvLJAie3Qnl+KbBxghI58LF4DgEHbZdqEpLIVoCIbOA9eFwpGUMXOzNbmTfQTD+LpHUEktCoIW6d7mQI4b2YJKcYy448rVGJk7K0fbbg8n"
}

5. Paste it in the Decrypt Connection String field and click on Decrypt

6. Copy the decrypted connection string and paste it in the Encrypt Connection String field 7. Update the connection string and click on Encrypt

8. Copy the encrypted connection string and replace it in the appsettings.json file 9. Recycle the Qommentary Engine application pool