Microsoft KB Archive/842907

= SQL Server CE 1.0 and later version client programs may not be able to connect to IIS on computers that are running Windows XP Service Pack 2 (SP2) =

Article ID: 842907

Article Last Modified on 1/3/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition 2.0
 * Microsoft Encarta Interactive World Atlas 2001
 * Microsoft SQL Server 2000 Windows CE Edition 1.1
 * Microsoft SQL Server 2000 Windows CE Edition 1.1 Service Pack 1
 * Microsoft SQL Server 2000 Windows CE Edition 1.1 Service Pack 1
 * Microsoft Internet Information Services 5.1, when used with:
 * Microsoft Windows XP Service Pack 2
 * Microsoft SQL Server 2005 Compact Edition

-



SYMPTOMS
When you run a Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) 1.0 or later version client program that connects to a computer that is running Microsoft Internet Information Services (IIS), you may receive an error message that is similar to the following:

Source: Microsoft SQL Server 2000 Windows CE Edition

Number: 80072EFF (ERROR_INTERNET_CONNECTION_RESET)

NativeError: 28037

Description: A request to send data to the computer running IIS has failed. For more information, see HRESULT. [,,,,,]

Additionally, if you try to access the URL for SQL Server CE Server Agent by using an Internet browser on the computer that is running IIS, you may not be able to access the URL. For example, the URL for SQL Server CE Server Agent may be http://myserver/sqlce/sscesa20.dll.

Note This problem may occur if IIS runs on a computer that is running Microsoft Windows XP Professional Service Pack 2 (Windows XP SP2).



CAUSE
By default, the firewall in Windows XP SP2 is turned on to prevent connections to IIS. Therefore, when an Internet client program, such as a SQL Server CE client program, tries to access IIS, the connection is not successful.



RESOLUTION
To resolve this problem, you must allow Internet users to access the Web Server (HTTP) service and the Secure Web Server (HTTPS) service on the computer that is running IIS. To do this, follow these steps:
 * 1) Click Start, click Run, type firewall.cpl, and then click OK.
 * 2) In the Windows Firewall dialog box, click the Advanced tab.
 * 3) In the Network Connection Settings box, click the connection that your computer uses, and then click Settings.
 * 4) In the Advanced Settings dialog box, click Web Server (HTTP), and then click Secure Web Server (HTTPS).

Note For additional information about when you must allow users to access the Secure Web Server (HTTPS) on your computer, see the &quot;More Information&quot; section.
 * 1) Click OK.
 * 2) In the Windows Firewall dialog box, click OK.

Note If you modify Windows Firewall settings to allow users to connect to the Web Server (HTTP) service and the Secure Web Server (HTTPS) service, it may expose your computer to security threats on your network. Make sure that you turn on these services only when the services are required.



MORE INFORMATION
You must allow users to access the Secure Web Server (HTTPS) service on a computer that is running Windows XP SP2 only when secure Web applications must connect to the computer. SQL Server CE 2.0 Replication and Remote Data Access (RDA) applications require the Secure Web Server (HTTPS) service to be accessible.

