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) (842907)


The information in this article applies to:

  • Microsoft SQL Server 2000 Windows CE Edition 2.0
  • Microsoft SQL Server 2000 Windows CE Edition
  • Microsoft SQL Server 2000 Windows CE Edition 1.1
  • Microsoft SQL Server 2000 Windows CE Edition 1.1 SP1
  • Microsoft SQL Server 2000 Windows CE Edition 1.1 SP1 Update
  • Microsoft Internet Information Services version 5.1, when used with:
    • the operating system: Microsoft Windows XP Professional Service Pack 2 (SP2)
  • Microsoft SQL Server 2005 Mobile 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 "More Information" section.
  5. Click OK.
  6. 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.

REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

310654 PRB: IIS Lock Down tool may break RDA or replication that uses Anonymous authentication

298804 Internet firewalls can prevent browsing and file sharing

283673 How to enable or disable Internet Connection Firewall in Windows XP

Modification Type:MinorLast Reviewed:11/1/2005
Keywords:kbtshoot kbFirewall kbClient kberrmsg kbSecurity kbReplication kbService kbServer kbDatabase kbprb KB842907 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.