---
title: "SQL Express Setup for On-Premises Mode"
slug: "sql-express-setup-for-on-premises-mode"
updated: 2025-09-09T13:05:19Z
published: 2025-09-09T13:05:19Z
canonical: "support.controlup.com/sql-express-setup-for-on-premises-mode"
---

> ## 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 Express Setup for On-Premises Mode

If you deploy SQL express for on-premises solution, be sure to enable the TCP/IP protocol in the SQL Configuration Manager.

By default the TCP\IP is disabled and also does not have any port assigned.

Once you enable the protocol, restart the SQL express service and then in the TCP/IP properties you will see the port number, before the restart the port is zero. ![TCP/IP properties popup](https://cdn.document360.io/098100b7-b9da-4bea-b4b9-017140ab863e/Images/Documentation/en-usarticleattachments1150013774092017-02-161631.png) After finishing the protocol and port setup, continue with the On-Premises [installation wizard](https://support.controlup.com/docs/controlup-on-premises-real-time-console-installation).