Create the Workspace ONE UEM SQL Account and Assign DB Owner Roles

Once the Workspace ONE UEM database has been created, you must configure the SQL user credentials. Learn how to create the SQL account and a assign the proper database owner roles.

After you create the Workspace ONE UEM database, you must configure the credentials of the SQL user that will run the Workspace ONE UEM database setup utility.

Procedure

1. Open SQL Server Management Studio.
2. Log in to the DB server containing the Workspace ONE UEM database.
3. Navigate to Security >  Login, right-click, and select New Login.
4. Select whether to use a Windows account or local SQL Server account for authentication. For SQL Server authentication, enter your user credentials.
5. Select the Workspace ONE UEM database as the Default database.
6. Navigate to the Server Roles tab. Select Server Role as Public.
7. Select User Mapping.
8. Select the Workspace ONE UEM Database. Then, select the db_owner role.
   1. For a successful installation, you must ensure that the SQL User you are planning to run the Workspace ONE UEM Database Script with has the database db_owner role selected.
   2. Select the msdb Database. Then, select the SQLAgentUserRole and db_datareader roles. SQLAgentUserRole is not pictured below.
      Note:

      The SQL user account used to install the DB will own SQL Server Agent Jobs and as such future upgrades require the same account to be used or an account with system admin level privileges.

9. Select OK.