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.
ReferenceMSDN: "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"