How to configure SQL Server 2017 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\MSSQL14.SQL2017\MSSQL\Binn\SQLServer.exe
      • C:\Program Files\Microsoft SQL Server\90\Shared\SQLBrowser.exe