Open SQL Management Studio

Right-click on the server and select Properties.

On the Connections tab check the Allow remote connections to this server

Open SQL configuration utility SQL Server Configuration Manager.

In the SQL Server Network Configuration section, select Protocols for <your instance name>

Ensure TCP/IP is Enabled. To edit this setting, right-click and select Properties.

If necessary, change the “Enabled” setting to “Yes”.

Select the IP Address tab (same dialog in step 4 above)

Scroll down to section titled IPAll

Update TCP Dynamic Ports. It should be blank.

Update TCP Port. It should be 1433.

Press OK to save changes. You will be prompted to restart the SQL service.

Select SQL Server Services

Select SQL Server (<your instance name>)

Select Restart

To enable the SQL Server Browser service, right-click on the Service and select Properties

On the Properties screen select Start Mode and update the setting to Automatic

Start the SQL Server Browser

If you are using the Windows firewall, you will need to open ports 1433 and 1434. Open the Windows Firewall

Select Advanced Settings

Create a new Inbound Rule by selecting Inbound Rules then New Rule

Select Port and Next

Select TCP and Specific local ports, then enter 1433

Choose Next to continue to the next screen

Select Allow the connection and choose Next

Select all three options and then press Next

Give the rule a name and press Finish

Confirm you see the new inbound rule

If you are using a named instance of SQL Server (Example: 192.168.5.30\SQLExpress) you will need to repeat these steps for port 1434 UDP