Base de conhecimento

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 do artigo: SLN290591

Data da última modificação: 08/28/2014 07:27 AM


Rate this article

Preciso
Úteis
Fácil de entender
Este artigo foi útil?
Sim Não
Envie seus comentários
Os comentários não podem conter estes caracteres especiais: <>()\
Infelizmente, o nosso sistema de feedback está atualmente desativado. Tente novamente mais tarde.

Agradecemos o feedback.