SQL Server and the Windows Server 2008 firewall
For those of you migrating from Windows Server 2003 or earlier to Windows Server 2008, if you have not previously heeded the advice to enable the firewall, you may be surprised by connectivity failures caused by the firewall (for any version of SQL) and you will need to take action to enable the connectivity you want.
Donít panic! Choosing the right firewall strategy isnít as hard as it may seem, and it will pay dividends over the long run.
[ Read more ]