How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server (841249)

INTRODUCTION

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. This article contains links to Microsoft Knowledge Base articles that you can use to help you configure Windows Firewall to permit access for SQL Server.

MORE INFORMATION

How to manually enable SQL Server connectivity on Windows XP SP2

If you only have some computers that are running SQL Server or if you prefer to use the Windows XP SP2 interface to configure Windows Firewall, click the following article number to view the article in the Microsoft Knowledge Base:

841251 How to enable SQL Server connectivity on Windows XP Service Pack 2

841252 How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000

841253 How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack 2

841549 How to enable ports on Windows XP Service Pack 2 for SQL Server 2000 Analysis Services and OLAP

842005 How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2

841256 How to enable SQL Server 2000 Analysis Services and OLAP Services on computers that are running Windows XP SP2

How to open ports for SQL Server or SQL Server Desktop Engine for use on computers that are running Windows XP SP2

If you have several computers that are running SQL Server or if you have a SQL Server Desktop Engine (also known as MSDE 2000) application that requires these changes, click the following article number to view the article in the Microsoft Knowledge Base:

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

Troubleshooting SQL Server and Windows XP Service Pack 2

These articles can help you resolve common issues with SQL Server on systems that are running Windows XP Service Pack 2

839269 You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2

839018 The NET SEND command may not work correctly on a computer that is running Windows XP Service Pack 2

839278 BUG: The changes in a remote subscriber are not updated to the publisher for a queued updating replication that uses Message Queuing on a computer that is running Windows XP Service Pack 2

839279 You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you install Microsoft Windows XP Service Pack 2

839280 BUG: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2