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 SP2If 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:
How to open ports for SQL Server or SQL Server Desktop Engine for use on computers that are running Windows XP SP2If 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:
Troubleshooting SQL Server and Windows XP Service Pack 2These articles can help you resolve common issues with SQL Server on systems that are running Windows XP Service Pack 2
Article ID: 841249 - Last Review: Sep 12, 2008 - Revision: 1