After you create the Microsoft SQL database, if the external database you created is not automatically configured in VMware Identity Manager, you configure VMware Identity Manager to use the database in the Appliance Settings page.

Prerequisites

  • The database with the saas schema created in Microsoft SQL server as the external database server. For information about specific versions that VMware Identity Manager supports, see the VMware Product Interoperability Matrixes.

Procedure

  1. In the VMware Identity Manager console, click Appliance Settings and select VA Configuration.
  2. Click Manage Configuration.
  3. Log in with the VMware Identity Manager administrator password.
  4. On the Database Connection Setup page, select External Database as the database type.
  5. Enter information about the database connection.
    1. Enter the JDBC URL of the Microsoft SQL database server.

      Authentication Mode

      JDBC URL String

      Windows Authentication (domain\user)

      jdbc:jtds:sqlserver://<hostname_or_IP_address:port#>/<saasdb>;integratedSecurity=true;domain=<domainname>;useNTLMv2=true

      SQL Server Authentication (local user)

      jdbc:sqlserver://<hostname_or_IP_address:port#>;DatabaseName=<saasdb>
      Note:

      To enable SQL Server Always on capability, MultiSubNetFailover to set to True in the SQL. The JDBC URL string is

      jdbc:jtds:sqlserver://<hostname_or_IP_address:port#>/<saasdb>;integratedSecurity=true;domain=<domainname>;useNTLMv2=true;multiSubnetFailover=true
    2. Enter the loginusername and password configured when you created the database. SeeConfigure Microsoft SQL Database Using Local SQL Server Authentication Mode
  6. Click Test Connection to verify and save the information.

What to do next

(Optional) Change the db_owner database role membership privileges. See Change Database-Level Roles.