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:
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:
- Click Start, click Run, type firewall.cpl, and then click OK.
- In the Windows Firewall dialog box, click the Advanced tab.
- In the Network Connection Settings box, click the connection that your computer uses, and then click Settings.
- 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.
- Click OK.
- 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
Additional query words: springboard sql server CE replication RDA fails
Keywords: kberrmsg kbtshoot kbserver kbservice kbfirewall kbdatabase kbsecurity kbprb kbclient kbreplication KB842907