Network Configuration of SQL Server

General

This article describes the steps required to prepare the previously installed SQL Server 2016 Express for external access via TCP/IP over port 1433.

Steps in Detail

Open the SQL Server Configuration Manager by launching mmc.exe (press the Windows key, type mmc.exe, and confirm with Enter) and browsing to the path C:\Windows\SysWOW64\SQLServerManager13.msc (File, Open, find the path, select it, and confirm with Open).

The console view appears:

Under SQL Native Client 11.0 Configuration, in the menu item Client Protocols, right-click TCP/IP, open the properties, and check whether port 1433 is entered.

Vergrößern

Under SQL Server Network Configuration, in the menu item Protocols for "SQLEXPRESS", right-click TCP/IP, open the properties, and on the Protocol tab change Enabled to Yes

Vergrößern

On the IP Addresses tab, at the very bottom under IPAll: delete TCP Dynamic Ports and enter TCP Port 1433
Set Enabled to Yes everywhere - Apply - OK

Vergrößern

Under SQL Server Services, restart the server

Vergrößern

In the Windows services, open the properties of the SQL Server service and on the Log On tab select "Local System account" - Apply - OK

Restart the server service