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
Accounts.
-
In the Connect To SQL Server dialog box, supply the SQL
Server authentication:
-
Select the authentication method to use by selecting either
Windows Authentication or SQL Server
Authentication.
-
If you have selected SQL Server Authentication, enter
your SQL login and password in the Login and
Password fields.
-
Click OK. The Fix VMP
Accounts window appears.
-
To add a new SQL account:
-
Click Add.
The New SQL Login dialog appears.
-
In the Login field, type the new SQL account
name.
-
In the Password field, type the password for the new
SQL account.
-
In the Confirm Password field, retype the password for
the account.
-
Click OK.
-
To edit an SQL account:
-
Highlight the account that you want to edit, and click
Edit.
The Edit SQL Login dialog appears.
-
In the Login field, edit the SQL account name if
needed.
-
In the Password field, type the new password for the
SQL account.
-
In the Confirm Password field, retype the new
password.
-
Click OK.
-
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.
-
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.
-
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
window.