Support‎ > ‎

How to configure SQL Server 2016 Express to allow remote connections?

Turn on TCP/IP
1. Open SQL Server Configuration Manager
2. SQL Server Network Configuration - Make TCP/IP Enabled

3. Restart SQL Server

Add Firewall Exceptions
  1. Click Start, click Control Panel, and then click System and Security.
  2. Under the Windows Firewall heading, click Allow a program through Windows Firewall.
  3. Add Firewall Exceptions for these 2 programs
    •  C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\Binn\SQLServer.exe
    •  C:\Program Files\Microsoft SQL Server\90\Shared\SQLBrowser.exe

See also