After you create the Microsoft SQL database, if the external database you created is not automatically configured in Workspace ONE Access, you configure Workspace ONE Access 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 Workspace ONE Access supports, see the VMware Product Interoperability Matrixes.

Procedure

  1. Log in to the Workspace ONE Access console.
  2. Select Dashboard > System Diagnostics Dashboard.
  3. Click VA Configuration of the service node you want to configure and log in with the admin user password.
  4. Click Database Connection.
  5. Select External Database as the database type.
  6. 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>

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

      For Windows Authentication
      jdbc:jtds:sqlserver://<hostname_or_IP_address:port#>/<saasdb>;integratedSecurity=true;domain=<domainname>;useNTLMv2=true;multiSubnetFailover=true
      For Local SQL
      jdbc:sqlserver://<hostname_or_IP_address:port#>;DatabaseName=<saasdb>;multiSubnetFailover=true
    2. Enter the loginusername and password configured when you created the database. See Configure Microsoft SQL Database Using Local SQL Server Authentication Mode for Workspace ONE Access
  7. 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 After Upgrade to Workspace ONE Access.