SQL Express Setup for On-Premises Mode

In case 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.

After finishing the protocol and port setup, continue with the On-Premises installation wizard.

Powered by Zendesk