Configuring Windows Firewall for SQL Server Database Engine access

Configuring Windows Firewall for SQL Server Database Engine access



Article Summary: This article addresses the configuration of the Windows Firewall to allow SQL Server Database Engine unrestricted access through the Windows Firewall



Solution:

Follow the steps in the solution to achieve this goal.

1. Press Windows Logo+R, type firewall.cpl and press Enter to open the Windows Firewall Control Panel tool.




2. Click Allow an app or feature through Windows Firewall on the left.

3. Scroll to the bottom and click Allow another app....




4. Click browse and browse to the location of sqlservr.exe. In this example it is installed in the default path for SQL Server 2012.

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqlservr.exe




5. Click Network Types..., select the Networks and click OK.



6. Click Add and click OK to complete the process.

Additional Information:

Additional information about Windows Firewall and SQL Server can be found on TechNet.




Quick Tips content is self-published by the Dell Support Professionals who resolve issues daily. In order to achieve a speedy publication, Quick Tips may represent only partial solutions or work-arounds that are still in development or pending further proof of successfully resolving an issue. As such Quick Tips have not been reviewed, validated or approved by Dell and should be used with appropriate caution. Dell shall not be liable for any loss, including but not limited to loss of data, loss of profit or loss of revenue, which customers may incur by following any procedure or advice set out in the Quick Tips.

文章 ID: SLN290591

上次修改日期: 08/28/2014 07:27 AM


為本文評分

準確
實用
易懂
這篇文章對您有用嗎?
傳送意見反應
評語中不得包含下列特殊字元:<>()\
很抱歉,我們的意見回饋系統目前關閉中。請稍後再試。

感謝您的寶貴意見。