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
Related Articles
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
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.
This post first appeared on Oracle ADF, BPM, BI And Primavera P6 Tutorials, please read the originial post: here