Base de connaissances

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


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.

Identificateur de l'article : SLN290591

Date de la dernière modification : 08/28/2014 07:27 AM

Évaluer cet article

Facile à comprendre
Cet article était-il utile?
Oui Non
Envoyez-nous votre évaluation
Les commentaires ne peuvent pas contenir ces caractères spéciaux : <>()\
Désolés, notre système d’évaluation n’est pas accessible actuellement. Veuillez réessayer plus tard.

Nous vous remercions pour vos commentaires.