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

View products that this article applies to.

Article ID	:	841249
Last Review	:	December 28, 2005
Revision	:	4.0

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.

Back to the top

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 (http://support.microsoft.com/kb/841251/) How to enable SQL Server connectivity on Windows XP Service Pack 2

841252 (http://support.microsoft.com/kb/841252/) How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000

841253 (http://support.microsoft.com/kb/841253/) How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack 2

841549 (http://support.microsoft.com/kb/841549/) How to enable ports on Windows XP Service Pack 2 for SQL Server 2000 Analysis Services and OLAP

842005 (http://support.microsoft.com/kb/842005/) How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2

841256 (http://support.microsoft.com/kb/841256/) How to enable SQL Server 2000 Analysis Services and OLAP Services on computers that are running Windows XP SP2

Back to the top

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 (http://support.microsoft.com/kb/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

Back to the top

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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/839018/) The NET SEND command may not work correctly on a computer that is running Windows XP Service Pack 2

839278 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/839280/) BUG: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2

842907 (http://support.microsoft.com/kb/842907/) SQL Server CE client programs may not be able to connect to IIS on computers that are running Windows XP SP2

Back to the top

REFERENCES

For more information about Windows XP SP2, visit the following Microsoft Web site:

http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2chngs.mspx (http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2chngs.mspx)

Back to the top

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

Back to the top

kbinfo KB841249

Back to the top

Search Support(KB)

Article Translations

Related Support Centers

•	SQL Server 2000

•	SQL Server 7.0

•	SQL Server 2005

•	Windows XP Embedded

•	Windows XP

Other Support Options

•	Contact Microsoft Phone Numbers, Support Options and Pricing, Online Help, and more.

•	Customer Service For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.