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.
Start the VMP Enterprise Manager.
From the Tools menu, select Fix VMP
In the Connect To SQL Server dialog box, supply the SQL
Select the authentication method to use by selecting either
Windows Authentication or SQL Server
If you have selected SQL Server Authentication, enter
your SQL login and password in the Login and
Click OK. The Fix VMP
Accounts window appears.
To add a new SQL account:
The New SQL Login dialog appears.
In the Login field, type the new SQL account
In the Password field, type the password for the new
In the Confirm Password field, retype the password for
To edit an SQL account:
Highlight the account that you want to edit, and click
The Edit SQL Login dialog appears.
In the Login field, edit the SQL account name if
In the Password field, type the new password for the
In the Confirm Password field, retype the new
To delete an SQL account, highlight the account that you want to delete, and click
In the confirmation dialog box that appears, click
To change a VMP SQL account,
in the VMP SQL Accounts pane, select the account that you want
- Authentication: The user authentication account.
- Application server: The VMP system application
- 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.
Click Start fixing. This runs a script that updates your SQL
database. The progress of the script is displayed in a dialog box.
When the script has completed, click OK to close the display