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.
    Attention: You must perform the rest of the procedure for the ODBC Data Source Administrator (64-bit). Only then the database connection details get updated.
  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
    1. On the Microsoft SQL Server DSN Configuration window, select the Server.
    2. Click Next.
    3. Select With Integrated Windows authentication.
    4. Click Next.
    5. Continue verifying the settings as per your requirement.
    6. Click Finish.
    7. Test the connection and save the settings.
    SQL Authentication
    1. On the Microsoft SQL Server DSN Configuration window, select the Server.
    2. Click Next.
    3. Select With SQL Server authentication using a login ID and password entered by the user.
    4. Click Next.
    5. Make changes as per your requirement and click Finish.
    6. Test the connection and save the settings.
    7. In the location where you have installed App Volumes, navigate to the config folder.

      For example: C:\Program Files (x86)\CloudVolumes\Manager\config

    8. Make a copy of the database.yml file as database.yml.bkp.
    9. Edit the database.yml file by using a text editor.
    10. In the file, after production, add the new username and password.
    11. Start the App Volumes Manager service.
  6. Follow the same procedure for ODBC Data Source Administrator (64-bit).