Microsoft KB Archive/841249

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

Article ID: 841249

Article Last Modified on 10/26/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft SQL Server 2000 Reporting Services
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server 7.0 Desktop Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Reporting Services
 * Microsoft SQL Server 2005 Analysis Services
 * Microsoft Windows XP Embedded

-



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.



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

842907 SQL Server CE client programs may not be able to connect to IIS on computers that are running Windows XP SP2

