Turning the firewall on

[tnt]

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

[Erland Sommarskog]

tnt (t...@discussions.microsoft.com) writes:
> 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 would use exceptions to open the port that SQL Server is listening on.
But I'm not a security expert. Maybe it's better to ask in a security forum.

--
Erland Sommarskog, SQL Server MVP, esq...@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