Changing the SQL Accounts for the VMP Server

If the SQL Server database has been updated, and some or all of the SQL accounts that the VMP Server uses have been removed, you can update the VMP Server to use the changed accounts.

1. Start the VMP Enterprise Manager.
2. From the Tools menu, select Fix VMP Accounts.
   
3. In the Connect To SQL Server dialog box, supply the SQL Server authentication:
   
   1. Select the authentication method to use by selecting either Windows Authentication or SQL Server Authentication.
   2. If you have selected SQL Server Authentication, enter your SQL login and password in the Login and Password fields.
   3. Click OK. The Fix VMP Accounts window appears.
      
4. To add a new SQL account:
   1. Click Add.
      

      The New SQL Login dialog appears.

      
   2. In the Login field, type the new SQL account name.
   3. In the Password field, type the password for the new SQL account.
   4. In the Confirm Password field, retype the password for the account.
   5. Click OK.
5. To edit an SQL account:
   1. Highlight the account that you want to edit, and click Edit.
      

      The Edit SQL Login dialog appears.

      
   2. In the Login field, edit the SQL account name if needed.
   3. In the Password field, type the new password for the SQL account.
   4. In the Confirm Password field, retype the new password.
   5. Click OK.
6. To delete an SQL account, highlight the account that you want to delete, and click Delete.
   

   In the confirmation dialog box that appears, click Yes.

7. To change a VMP SQL account, in the VMP SQL Accounts pane, select the account that you want to change:
   • Authentication: The user authentication account.
   • Application server: The VMP system application account.
   • Instance: name: The account that you use to log in to the VMP Server database named name. A standard installation of the VMP Server has a database named MAIN.

   From the dropdown list in the SQL Login column, select the VMP SQL account that you want to use.

8. Click Start fixing. This runs a script that updates your SQL database. The progress of the script is displayed in a dialog box.
9. When the script has completed, click OK to close the display window.