---
title: "SQL Server Prerequisites for On-Premises Installation"
slug: "sql-server-prerequisites-for-on-premises-installation"
updated: 2023-07-26T09:47:28Z
published: 2023-07-26T09:47:28Z
canonical: "support.controlup.com/sql-server-prerequisites-for-on-premises-installation"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.controlup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.