How to open the fire ports for your SQL Server 2008

Here is a good article and script to setup your SQL server's firewall:

http://support.microsoft.com/kb/968872