2011-02-10

Windows 2008 Firewall

There are several guides on how to configure the Windows Server 2008 (R2) firewall to allow SQL Server access.
I would like to add some items to the rule definition:

  • Specify both program (sqlservr.exe) and service.
  • Specify the interface type, typically Local area network.
Also I think other issues like the scope should be considered to make the rule as tight as possible.

Reference

MSDN: "How to: Configure a Windows Firewall for Database Engine Access"
Shawn Hernan: "SQL Server and the Windows Server 2008 Firewall"
Ashish Kumar Mehta: "Configure Windows Firewall for SQL Server 2008 Database Engine in Windows Server 2008 R2"

No comments: