SQL Server Prerequisites for On-Premises Installation

ControlUp On-Premises (COP) uses Microsoft’s SQL Server to store and retrieve data, such as Script-based Actions (SBAs), trigger incidents, or historical data for Insights On-Premises. During the installation of the On-premises server, you can choose between a Light Mode or Production Mode installation. If you select Production Mode, you need to provide the name of your SQL Server instance, the database name that you preconfigured, and the authentication mode, which can be either Windows or SQL Authentication.

Prerequisites

When you use ControlUp On-Premises with your own SQL Server Database, make sure that your SQL Server meets the following requirements:

• SQL Server 2022, 2019, 2017, 2016, or 2014
• Editions: Standard or Enterprise
• 10 GB of free disk space on the partition where SQL data will be stored

The user that you provided in the on-premises installation wizard must be assigned the db_owner database role. The default database name in the installation wizard is shown as ControlUpDB. This may be changed based on your organization's requirements. Be aware that the database must already exist during installation, otherwise you are not able to continue with the on-premises server installation.