# Platform pre-requisites

Review the [Planning Guide](https://docs.adaptiva.com/platform-install/planning-guides/onesite-platform-planning) prior to installation.

The OneSite Platform installation requires two files from the **Installer\Windows** folder:

`adaptiva-server-<version>-windows.exe`

`adaptiva-client-<version>-windows.exe`

The server needs to install the server and client files in order to communicate effectively with client devices. However, the client installed on the server does not operate in the same way as a client installer on a client device and does not participate in peer-to-peer sharing.

{% hint style="info" %}
The `<version>` placeholder refers to the downloaded version of the executable.

All components require local administrator privileges to install.
{% endhint %}

## Verify connectivity

Please refer to the [communication port requirements](https://docs.adaptiva.com/platform-install/additional-configuration/platform-communication-ports) 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.

When integrating with Configuration Manager, the user must have permission to the Configuration Manager Site and file server, as well as sysadmin permissions in the SQL Server hosting the ConfigMgr database.

These permissions are only required for the setup and can be reduced after successful installation. You can review the [Account Permissions](https://docs.adaptiva.com/platform-install/planning-guides/onesite-platform-planning#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:

   ```sql
   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.

   ![](https://1238239958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzBcNZqjCKqgdpA83eD4o%2Fuploads%2Fgit-blob-bc85a9ea7e372ce54984e8f2293a985e00dee40a%2Fimage2.png?alt=media)
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

   ![](https://1238239958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzBcNZqjCKqgdpA83eD4o%2Fuploads%2Fgit-blob-10c2381bf9c0b41a8a57d1f7e062dc281a94d057%2Fimage3.png?alt=media)
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](https://docs.omnissa.com/bundle/AirWatchCloudConnectorVSaaS/page/EnableAirWatchCloudConnectorfromtheWorkspaceONEUEMconsole.html).

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**

   ![](https://1238239958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzBcNZqjCKqgdpA83eD4o%2Fuploads%2Fgit-blob-8ed344f4b34742cc46a69f6dc0ab1ed02fba630f%2Fimage21.png?alt=media)
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

   ![](https://1238239958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzBcNZqjCKqgdpA83eD4o%2Fuploads%2Fgit-blob-6cf31b7b5e0bb41e8b8251cfd612eabebd9873da%2Fimage22.png?alt=media)
3. On the **End-User License Agreement** screen click **Accept**

   ![](https://1238239958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzBcNZqjCKqgdpA83eD4o%2Fuploads%2Fgit-blob-0164083e13e3d4eac8d172e73d607982e60990b6%2Fimage23.png?alt=media)
4. The dialog will show current installation status, click **Install**

   ![A screenshot of a computer AI-generated content may be incorrect.](https://1238239958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzBcNZqjCKqgdpA83eD4o%2Fuploads%2Fgit-blob-67800a430b536dfbafc4f9371e947c92519fee0f%2Fimage24.png?alt=media)
5. When prompted: **Are You Sure you Wish To Install Adaptiva DLLs?**, click **Yes**
6. When prompted that the **Installation Was Successful**, click **OK**
