Importing Users From SQL

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.

  1. Select Users & Groups > Users.
    .
  2. Click Synchronization in the Users view.
  3. 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.
  4. In the User Synchronization dialog, click Add primary source with users (under Sources).
  5. 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.
  6. 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.
  7. Optionally specify the import source options described in Specifying Source Importing Options.
  8. Click OK to close the dialog.
  9. Follow the steps in Synchronizing Users and Contacts to synchronize the SQL users and contacts with the VMP Server.