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.



  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)
      SQL Server Authentication (local user)

      To enable SQL Server Always on set MultiSubNetFailover to True in the JDBC URL.


      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.