How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2 (839980)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
- Microsoft SQL Server 2000 Desktop Engine (MSDE)
- Microsoft SQL Server 7.0
- Microsoft SQL Server, Desktop Edition
- the operating system: Microsoft Windows XP SP2
- 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
INTRODUCTIONMicrosoft
Windows XP Service Pack 2 (SP2) includes Windows Firewall. Windows Firewall is
an enhanced version of Internet Connection Firewall (ICF). By default, Windows
Firewall is enabled on computers that are running Windows XP Service Pack 2.
Windows Firewall will block some network connections that use TCP/IP, that use
Named Pipes, or that use Multiprotocol Remote Procedure Call (RPC). This
blocking can affect Microsoft Data Engine (MSDE), Microsoft SQL Server 2000, and Microsoft SQL Server 2005.
If you have an application that requires SQL Server or MSDE to have
access to the network by using Named Pipes, by using TCP/IP, or by using RPC, you can use the scripts that are
provided in the "More Information" section to open the required ports
programmatically instead of using Windows Firewall. Two scripts are
included in this article. The first script programmatically configures Windows
Firewall to allow SQL Server to listen on the network on all protocols. The
second script programmatically configures Windows Firewall to allow SQL Server
to listen on TCP/IP only. Note We recommend that you open ports on an as-needed basis only.
The scripts that are discussed in this article provide
Multiprotocol (RPC) over Named Pipes access only. If you are running RPC over
TCP, see the following Microsoft Knowledge Base article for information about
using TCP/IP: 841252 How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000
REFERENCES
For additional information about configuring SQL
Server 2000 and Windows XP Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
841249
How to configure Windows XP Service Pack 2 (S) for use with SQL Server
Modification Type: | Minor | Last Reviewed: | 1/11/2006 |
---|
Keywords: | kbFirewall kbinfo KB839980 kbAudDeveloper |
---|
|