The new firewall in Windows XP SP2 stops SQL Server from working when I do a default installation of SP2. How do I ensure SQL Server will continue to work after installing SP2?
Microsoft Windows XP Service Pack 2 (SP2) includes Windows Firewall. Windows Firewall is an enhanced version of Internet Connection Firewall (ICF). Windows Firewall is a host-based, stateful, filtering firewall that discards unsolicited incoming traffic through TCP/IP version 4 (IPv4) connections and through TCP/IP version 6 (IPv6) connections. By default, Windows Firewall is enabled on computers that are running Windows XP SP2. Because Windows Firewall is enabled, Microsoft SQL Server cannot listen to the network, even if it was previously configured to do this. For further information, please see the Microsoft FAQ How Windows XP Service Pack 2 (SP2) Affects SQL Server and MSDE, or refer to Microsoft Knowledge Base article 841249 . Alternatively, if you have 90 minutes to kill then you can watch the MSDN Webcast: SQL Server and Windows XP SP2.
