QuoteWerks Knowledgebase Topic (Article ID 6131)
MSDE/SQL on Windows XP Firewall Issues
This information applies to :
August 16, 2005
You have MSDE installed on an Windows XP SP2 machine and other computers on the network cannot access it.
The Windows XP SP2 Firewall may be preventing the sharing of the MDSE/SQL Server.
From the microsoft article: http://support.microsoft.com/default.aspx?kbid=841251
How to enable SQL Server connectivity on Windows XP Service Pack 2
This article describes how to enable SQL Server connectivity on Windows XP Service Pack 2.
By default, Windows Firewall is enabled on computers that are running Microsoft Windows XP Service Pack 2. Windows Firewall closes ports such as 445 that are used for file and printer sharing to prevent Internet computers from connecting to file and print shares on your computer or to other resources. When SQL Server is configured to listen for incoming client connections by using named pipes over a NetBIOS session, SQL Server communicates over TCP ports and these ports must be open. SQL Server clients that are trying to connect to SQL Server will be not be able to connect until SQL Server is set as an exception in Windows Firewall. To set SQL Server as an exception in Windows Firewall, use the steps that are listed in the "More Information" section.
Create an exception for each instance of SQL Server
The following method will open User Datagram Protocol (UDP) port 1434 in addition to the Transmission Control Protocol (TCP) port.
Note If you are running multiple instances of SQL Server, you will have to create an exception for each instance.
1. Click Start, and then click Run.
2. In the Run dialog box, type Firewall.cpl, and then click OK.
3. In the Windows Firewall dialog box, click Add a Program on the Exceptions tab.
4. In the Add Program dialog box, you can select an instance of SQL Server or you can click the Browse button to locate the instance of SQL Server that you want to add to the exception list. The default installation locations for SQL Server are listed in the following table.
Version File path
SQL Server 7.0 Mssql\Binn\Sqlservr.exe
SQL Server 2000 Default Instance Program Files\Microsoft SQL Server\Mssql\Binn\Sqlservr.exe
SQL Server 2000 Named Instance Program Files\Microsoft SQL Server\Mssql$instancename\Binn\Sqlservr.exe
5. Select the name of the instance, and then click OK.
6. Under Programs and Services, select the check box that is next to the name you selected in step 6, and then click OK.
How to use Multiprotocol Remote Procedure Call (RPC)
If you are using Multiprotocol, you must perform the steps in the "Create an exception for each instance of SQL Server" section as well as open the correct TCP ports on Windows Firewall.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)