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 Click Start, click Control Panel, and then click System and Security. Under the Windows Firewall heading, click Allow a program through Windows Firewall. 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 How to install Microsoft SQL Server 2016 Express Edition for HRPro