You are currently offline, waiting for your internet to reconnect

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

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

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
842907 SQL Server CE client programs may not be able to connect to IIS on computers that are running Windows XP SP2
REFERENCES
For more information about Windows XP SP2, visit the following Microsoft Web site:
springboard
Properties

Article ID: 841249 - Last Review: 10/26/2007 08:13:05 - Revision: 4.5

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, 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, Windows XP Embedded

  • kbinfo KB841249
Feedback
/body>html> var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write("