This method will open all ports for access to SQL Server. From the New Inbound Rule Wizard, select Port.Īllow the SQL Server applications in the Firewall.Select Inbound Rules from the left hand column.Ĭlick New Rule. From the Windows Defender Firewall window, click Advanced Settings.įrom the Windows Defender Firewall with Advanced Security window:.From the System and Security window, click Windows Defender Firewall.

Open Windows Control Panel and select System and Security.

This method will target the specific ports SQL Server uses for communication.

Allow the SQL Server applications in the FirewallĬreate Inbound Rules for the SQL Server Ports.

Create Inbound Rules for the SQL Server Ports.

There are two methods for configuring Windows Firewall for SQL Server.Ĭhoose one of the two methods below, that best suits your IT policy:

You need to be a member of the Administrators group to perform the steps in this document. It is also assumed that you have configured SQL Server for remote access, either manually, or by following the steps in How To: Configure SQL Server for Remote Access. Other Firewalls may have similar settings that can be applied. This article only applies to Windows Defender Firewall. To follow the steps in this document you will need to have one of the versions of SQL Server running on one of the versions of Windows mentioned above.

Microsoft SQL Server Compact Edition 4.0 or later.

Microsoft SQL Server Express/Standard or higher editions 2012 or later.

This document will show you how to open remote access to SQL Server by configuring Windows Firewall.

How To: Configure Windows Firewall for SQL Server

Windows firewall remote management