If you have your own SQL database for keeping track of user information, you can
import the users from this database into the VMP Server.
-
Select Users & Groups > Users.
.
-
Click Synchronization
in the Users view.
-
If you have previously imported one or more sources into the
VMP Server,
the Reconfigure/Synchronize only window appears. Select
Yes, reconfigure settings and click
Next.
-
In the User Synchronization dialog, click Add
primary source with users
(under Sources).
-
Select MsSqlServer from the Source
type dropdown list. This selection auto-populates the
Title field. You can accept the default title or customize
the title.
-
Enter the Connection Parameters.
Table 1. SQL connection parameters
Parameter |
Description |
Address
|
The computer name or IP address of the SQL server. |
Login
|
The SA login credentials. |
Password
|
Confirm Password
|
Enter the password a second time to confirm the
credentials. |
Database
|
Select the database to import from the dropdown list. |
Query
|
Use the dropdown list to select any specifc query options for the
import. |
-
Optionally specify the import source options described in Specifying Source Importing Options.
-
Click OK to close the dialog.
-
Follow the steps in Synchronizing Users and Contacts to synchronize the
SQL users and contacts with
the VMP Server.