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



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 de l'article : SLN290591

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


Noter cet article

Précis
Utile
Facile à comprendre
Avez-vous trouvé cet article utile ?
Oui Non
Envoyez-nous vos commentaires
Les commentaires ne doivent pas contenir les caractères spéciaux : <>()\
Désolé, notre système de collecte des commentaires est actuellement indisponible. Veuillez réessayer ultérieurement.

Merci pour vos commentaires.