# DB Connection Utility

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

The *DB Connection Utility* allows you to easily decrypt, update and encrypt the database connection string to update parameters such as database hostname, username or password.

![](https://409486811-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-M5Hu_po6LKJPl3U-plc%2F-M5HwqHWW2Lj2_OegqT6%2Fimage.png?alt=media\&token=ae62e835-822b-4192-8bf4-6a756e36c794)

To update the connection string, please follow these steps:

1\.  Download the [**DB Connection Utility**](https://www.qommentary.com/downloads/utilities/Qommentary_DB_Connection_Utility.zip)\
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**

![](https://409486811-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-M5paKPqoz5d_B1UXhWq%2F-M5ptLBWkDB0v9hvwREK%2Fimage.png?alt=media\&token=15cbc41c-04ff-49f9-8ff4-ce36bf588c05)

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

![](https://409486811-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-M5pw4M79YKUaCFOLouz%2F-M5pwHe08IXoCzAGUGcP%2Fimage.png?alt=media\&token=ffcfb737-d578-4228-8f55-f31c1b5ae185)

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