Update Database Credentials For App Volumes Manager

You can update the connection details for App Volumes Manager by updating the database credentials. Your database connection can use either the Windows Integrated authentication method or the SQL Authentication method.

App Volumes Manager UI displays ODBC errors, which can help you troubleshoot database.yml file syntax issues.

When the App Volumes Manager service starts, the cleartext password is replaced by an encrypted stamp.

Prerequisites

While editing the .yml file, ensure that you follow the YAML syntax.

Procedure

1. On the virtual machine that runs the App Volumes Manager service, stop the service.

2. In the Control Panel, open the ODBC Data Source Administrator (32-bit) tool.

3. In the System DSN tab, select svmanager.

4. Click Configure.

5. Depending on the mechanism used by your database to connect to the App Volumes Manager server, perform the following steps:

   Option	Steps
   Integrated Windows Authentication	On the Microsoft SQL Server DSN Configuration window, select the Server. Click Next. Select With Integrated Windows authentication. Click Next. Continue verifying the settings as per your requirement. Click Finish. Test the connection and save the settings. For the database connection details to get updated, you must repeat the steps performed until now for ODBC Data Source Administrator (64-bit) as well.
   SQL Authentication	On the Microsoft SQL Server DSN Configuration window, select the Server. Click Next. Select With SQL Server authentication using a login ID and password entered by the user. Click Next. Make changes as per your requirement and click Finish. Test the connection and save the settings. For the database connection details to get updated, you must repeat the steps performed until now for ODBC Data Source Administrator (64-bit) as well. In the location where you have installed App Volumes, navigate to the config folder. For example: C:\Program Files (x86)\CloudVolumes\Manager\config Make a copy of the database.yml file as database.yml.bkp. Using a text editor, edit the database.yml file. In the file, after >production, add the new username and password. To add the password after the username field, press enter, leave two spaces, type *password* followed by a colon (password:), and enter the actual password. Start the App Volumes Manager service.