11 total views, 0 views today

Configure Windows Firewall for Microsoft SQL Server 2017 – Part 4

This is the continuation if Microsoft Sql Server installation series. In this section, we walk through how to allow Windows Firewall to work with Microsoft SQL Server. Follow the links if you are interested in Microsoft SQL Server Installation

Microsoft SQL Server Installation

Create a Database in Microsoft SQL Server

Installation of Microsoft SQL Server Management Studio

Allow Firewall to connect to MS SQL Server

Follow the points to allow outside application to connect to Microsoft SQL Server through Windows Firewall

1. Type in Firewall and select Windows Firewall and Select Advanced Security a shown below

2. Add inbound Rule to allow the MS SQL Port in Windows Firewall (Change the port if it is a custom port)

3. Open Windows Start Menu > Go to Index under M >> Select SQL Server Configuration Manager

4. Expand SQL Server Network Configuration > Select the Protocols for > Double click on the TCP/IP > Select the Protocol Tab > set the property Enable = Yes

5. Now click on the IP Address tab > Set the Enabled = Yes, Dynamic Port= blank for all the protocols and Click Ok

6. Open Windows Services >> Restart Microsoft SQL Servers || Restart the Machine. That’s it. Try an external application to connect to Microsoft SQL Server.