Article ID: 842907 - View products that this article applies to.
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:
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.
Source: Microsoft SQL Server 2000 Windows CE Edition
Number: 80072EFF (ERROR_INTERNET_CONNECTION_RESET)
Description: A request to send data to the computer running IIS has failed. For more information, see HRESULT. [,,,,,]
Note This problem may occur if IIS runs on a computer that is running Microsoft Windows XP Professional Service Pack 2 (Windows XP SP2).
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.
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:
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.
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/310654/ )PRB: IIS Lock Down tool may break RDA or replication that uses Anonymous authentication
(http://support.microsoft.com/kb/298804/ )Internet firewalls can prevent browsing and file sharing
(http://support.microsoft.com/kb/283673/ )How to enable or disable Internet Connection Firewall in Windows XP
Article ID: 842907 - Last Review: January 3, 2007 - Revision: 4.6