Configure Workspace ONE Access to Use an External Database

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 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.
• If you are changing the Microsoft SQL database configuration, make sure that the database user is granted the db_owner role. Members of the db_owner database role can perform all configuration and maintenance activities on the database. See Change Database-Level Roles After Upgrade to Workspace ONE Access.

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 set MultiSubNetFailover to True in the JDBC URL.

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

      MultiSubnetFailover is not supported when using Windows Authentication.

   2. Enter the login user name 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 access to the database and to 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.