Platform pre-requisites

Verify connectivity

Please refer to the communication port requirements and ensure your server has proper communication with cloud services.

In the case of a SQL Server Express Edition installation, your server will need to connect to *.adaptivacdn.cloud to download SQL Express.

Verify user permissions

When using an existing SQL Server installation, the user performing the server installation MUST have sysadmin permissions in the SQL Server that will host the Adaptiva database.

These permissions are only required for the setup and can be reduced after successful installation. You can review the Account Permissions section of the Planning guide for additional information.

Database Reporting Account

Starting in Build 8.3, you will need to create a database reporting account to ensure that the Adaptiva Server is operating at the highest level of security for your SQL Server environment. All data providers in the Adaptiva Server will use this account to query the Adaptiva database. The account will only be granted db_datareader permissions, ensuring that the account cannot change any data in the Adaptiva database or any other database hosted on the database server.

NOTE: A domain account is recommended for use as the database reporting account.

IMPORTANT: When SQL Server is remote from the Adaptiva Server, the installation will only be able to use a domain account. If a SQL account is required, open a support ticket.

When you install Adaptiva Server, the install will automatically grant permissions to the specified account.

SQL Express

If selecting SQL Express Edition during installation, see the following pre-requisites

Internet Access

If selecting SQL Express Edition during installation, the server must be able to connect to the internet to download Microsoft SQL Server Express Edition. This is only required if Express Edition will be installed during the Adaptiva Server installation.

If using the Cloud Edition, the Adaptiva Server must also be able to reach http(s)://services.adaptiva.cloud.

SQL Express pre-installed

If SQL Express has been installed beforehand, make sure the following configuration changes have been made.

TCP/IP connections must be enabled

  1. Open SQL Server Configuration Manager.

  2. Expand SQL Server Network Configuration (not 32-bit), and select Protocols for MSSQLSERVER or the Instance name used.

  3. Enable TCP/IP if not already.

  4. Enable Shared Memory but Named Pipes can stay Disabled.

Enable SQL Server Browser

  1. Select SQL Server Services.

  2. Right-click SQL Server Browser and select Properties.

  3. Confirm the Log on as setting is for Local Service.

  4. Click Start.

Grant Local System account Sysadmin role

You can reduce account permissions after installation.

  1. Install SQL Server Management Studio.

  2. If the account does not exist under Security | Logins run the following T-SQL command:

    CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english];GO
    ALTER SERVER ROLE [sysadmin] ADD MEMBER [NT AUTHORITY\SYSTEM];GO

SQL permissions

If SQL Express Edition will NOT be used, then prior to installing the Adaptiva Server, the installation account (and service account, if planned to use) and the Adaptiva Server SYSTEM account must be granted sysadmin permissions in SQL, to allow the creation of the Adaptiva database and the connections to the ConfigMgr database if that is being used. Once the installation is complete, these permissions can be reduced for day-to-day operations if required.

Pre-Install Instructions

  1. In SQL Management Studio object explorer, expand the Security folder, right-click the Logins folder and select New Login...

  2. Click on Search..., then ensure the Location is set to the domain and enter the username of the account performing the installation or will be the service account, click on Check Names, then OK

  3. Select the Server Roles page and check the box for the sysadmin role.

  4. Click OK to add the login.

Additional prerequisites for ConfigMgr

  1. Using SQL Management Studio, expand the Security folder and select Properties for the installation and/or service account

  2. Select the User Mapping page, in the Users mapped to this login section, check the box next to the name of the ConfigMgr database and in the Database role membership section, check the box for the db_owner role

  3. Click OK

Workspace ONE

The following steps must be completed before starting the Adaptiva Server installation. There are also post-installation steps that will need to be completed.

Install/Update the Cloud Connector

The AirWatch Cloud Connector (ACC) component must be installed before installing the Adaptiva Server. Make sure it is the proper version. For instructions on this, see the omnissa Workspace ONE documentation library.

  1. If the ACC is already installed, open the log file CloudConnect.log in %InstallPath%\Airwatch\Logs\CloudConnector.

  2. Search for Starting CloudConnector. The version should be 19.7.0.0 or later.

  3. If it is not 19.7.0.0 or later, open the Workspace ONE UEM console and navigate to: Groups & Settings | All Settings | System | Enterprise Integration | Cloud Connector. Select Download AirWatch Cloud Connector Installer and install.

  4. Click on Test Connection and validate the AirWatch Cloud Connector is active.

Download the Certificate

Download the vSEC certificate for the current instance of Workspace ONE.

  1. Open the Workspace ONE UEM console and navigate to: Groups & Settings | All Settings | System | Enterprise Integration | Peer Distribution | Adaptiva

  2. Click the link to Download vSEC Certificate and store it in a convenient location as it will be needed later. Return to this page after the installation of Adaptiva to upload the Adaptiva certificate and provide the name or IP address of the Adaptiva server.

Installing the Adaptiva APIs

The ACC will require access to Adaptiva DLLs in order to call the APIs provided by Adaptiva. To install these on the server hosting the ACC follow these steps:

  1. Navigate to the Adaptiva Installation source folder

  2. Run the AdaptivaWorkspaceONEACCInstaller.exe as an administrator and click Yes if prompted

  3. On the End-User License Agreement screen click Accept

  4. The dialog will show current installation status, click Install

    A screenshot of a computer AI-generated content may be incorrect.
  5. When prompted: Are You Sure you Wish To Install Adaptiva DLLs?, click Yes

  6. When prompted that the Installation Was Successful, click OK

Last updated

Was this helpful?