Not exactly .NET related, but very current info. After an MSDE user installs XP SP2, can't remote connect to their MSDE.

Here's info on how to come up with a script that we could mail to them.

839980 - How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2

netsh firewall command info

basic syntax:

netsh firewall ?
netsh firewall set portopening ?
netsh firewall set portopening tcp 1433 SQL1433

netsh firewall delete portopening tcp 1433


some other syntax for the current subnet or a custom network subnet

netsh firewall set portopening tcp 1433 SQL1433 ENABLE SUBNET

netsh firewall set portopening tcp 1433 SQL1433 ENABLE CUSTOM 10.0.0.0/255.0.0.0