How to block all traffic but SQL Server

From: hug gozz (
Date: 06/04/05

Date: Sat, 04 Jun 2005 03:02:36 GMT

We are installing a new server, and it is suppose to be used ONLY for SQL
SERVER 2000, how can I block all traffic and all ports and allow only the
ports used by SQL Server?
Norton Security is not working right, some time it blocks legit queries and
access to SQL Server.
Thanks, I have to choose our next firewall program and I dont know the best
for this job.