Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 841249 - Last Review: October 26, 2007 - Revision: 4.5
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=841251/
)
How to enable SQL Server connectivity on Windows XP Service Pack 2
841252Â
(http://kbalertz.com/Feedback.aspx?kbNumber=841252/
)
How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000
841253Â
(http://kbalertz.com/Feedback.aspx?kbNumber=841253/
)
How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack 2
841549Â
(http://kbalertz.com/Feedback.aspx?kbNumber=841549/
)
How to enable ports on Windows XP Service Pack 2 for SQL Server 2000 Analysis Services and OLAP
842005Â
(http://kbalertz.com/Feedback.aspx?kbNumber=842005/
)
How to enable the ISAPI component
on SQLXML on Windows XP Service Pack 2
841256Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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://kbalertz.com/Feedback.aspx?kbNumber=839018/
)
The NET SEND command may not work correctly on a computer that is running Windows XP Service Pack 2
839278Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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://kbalertz.com/Feedback.aspx?kbNumber=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://kbalertz.com/Feedback.aspx?kbNumber=839280/
)
BUG: SQL debugging does not work in Visual Studio .NET after you install Windows XP Service Pack 2
842907Â
(http://kbalertz.com/Feedback.aspx?kbNumber=842907/
)
SQL Server CE client programs may not be able to connect to IIS on computers that are running Windows XP SP2
For more information about Windows XP SP2, visit the
following Microsoft Web site:
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, 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
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please