Checklist to allow remote connection to SQL Server

Every time I setup a new SQL Server I always forget one or more of the steps below to allow remote connection from another workstation via SSMS.

 

1.       SQL Server Properties: check “Allow remote connections to this server”

2.       SQL Server Configuration Manager: Enable TCP/IP

3.       Windows Firewall – Add Inbound Rule for the SQL Server port.

 

For detailed steps check out:  Resolving could not open a connection to SQL Server errors  By: Jugal Shah