Enable auditing for Windows Firewall

Recently when troubleshooting a new IIS application deployment, I realized how helpful the windows firewall auditing feature is. The IIS application was having difficulty connecting to SQL Server. I had allowed outbound connecting to the SQL Server from IIS. However, after enabling the Windows auditing on packet filtering I discovered that connections back to the IIS server on port 1434 were being blocking.

windowsfirewallaudit

Example of a failure audit
failureaudit

Advertisements