ControlUp On-Premises Database
    • Dark
      Light
    • PDF

    ControlUp On-Premises Database

    • Dark
      Light
    • PDF

    Article summary

    Introduction

    The ControlUp On-Premises (COP) deployment requires a database to store incidents, script actions, and virtual expert recommendations. The following article provides information on how to install and configure a COP database.

    Supported SQL Server Versions

    The following Microsoft SQL Server versions are supported when you choose your own SQL Server instance. For more information, see Production Mode.

    • Microsoft SQL Server 2022, 2019, 2017, 2016, or 2014. Database products from other vendors are not supported.
    • Express, Standard, or Enterprise Edition.

    Prerequisites

    • If you use production mode, the ControlUp database you specify during installation must exist before you install COP.
    • The database collation must be SQL_Latin1_General_CP1_CI_AS.
    • The user you specify during the installation must have the following permissions:
      • ALTER SCHEMA
      • CREATE PROCEDURE
      • CREATE TABLE
      • CREATE VIEW
      • CREATE FUNCTION
      • SELECT / INSERT / UPDATE / DELETE / EXECUTE
    • The user you specify must be granted the db_owner user role.

    Deployment Mode

    When you install the COP server, by default, it deploys in Production Mode.

    Light Mode

    From the 8.8 Maintenance Release, COP no longer supports Light Mode deployment as a built-in installation option. If you want to perform a Light Mode installation, you must download and install SQL Server Express, and provide it as a Production Server. Due to limited performance and database size, we only recommend Light Mode for small ControlUp environments or POCs.

    Production Mode

    Production Mode is the recommended deployment type for production environments as it provides more configuration options. Before deployment, you must first create the ControlUp database.

    Note

    You should only use Production Mode for production environments.

    Preparation for Production Mode

    To prepare the ControlUp database, you can use SSMS or any other compatible tool.

    1. Open SSMS and connect to the SQL Server instance. After you connect, right-click Database > New Database...
      image.png
    2. Enter the database name. We recommend keeping the name ControlUpDB. As the Owner, select the database owner. Make sure that this user has the db_owner member role.
    3. In the COP installation wizard, provide the following database details:
      image.png
    • SQL Server. The FQDN or IP address of the SQL Server instance.
    • Port. By default, SQL Server listens on TCP port 1433. If another port is used, change the port number as needed.
    • Authentication. Define how the user needs to authenticate to the ControlUp database. Make sure that the user you define here is already created on the SQL Server instance.
      • Windows Integrated Authentication. Active Directory user for authentication.
      • SQL Authentication. An SQL user with a password.
    • Encrypt DB Connection. Encrypts the data in transit. We recommend activating this checkbox as it helps prevent man-in-the-middle attacks.
    • Trust Server Certificate. Forces the certificate of the server to be trusted, even when the certificate is not issued by a Certification Authority. It is best practice to keep this box unchecked.
    • Skip DB validations. When checked, the installer does not run the prerequisite check.
    • Upgrade Existing DB. Update an existing ControlUp database. Make sure you provide the same database name and SQL Server instance. Once a database is found, the installer will automatically update the database to the latest ControlUp version.
    • Certificate. If you don't select the Trust Server Certificate, you need to provide an X509 certificate that should already exist in the Local Certificate Store on your SQL Server. In the Certificate Password field, provide a password which is required to access the X.509 certificate data.

    Was this article helpful?