Turning the firewall on

Hello,

I have a windows 2003 sp2 hosting sql 2005 Ent sp2.  I like to turn on
firewall.

Do use the exception to allow certain ports or do I allow the program to be
accessed.

I have clients on other machines connecting to his database server.  I think
name pipe is needed.  Not sure.

tnt

tnt (tnt@discussions.microsoft.

tnt (tnt@) writes:

I would use exceptions to open the port that SQL Server is listening on.
But I am not a security expert. Maybe it is better to ask in a security forum.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx