Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 842907 - Last Review: January 3, 2007 - Revision: 4.6
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)
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:
- 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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=310654/
)
PRB: IIS Lock Down tool may break RDA or replication that uses Anonymous authentication
298804Â
(http://kbalertz.com/Feedback.aspx?kbNumber=298804/
)
Internet firewalls can prevent browsing and file sharing
283673Â
(http://kbalertz.com/Feedback.aspx?kbNumber=283673/
)
How to enable or disable Internet Connection Firewall in Windows XP
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 Service Pack 1
- the operating system: Microsoft Windows XP Professional Service Pack 2 (SP2)
- Microsoft SQL Server 2005 Compact Edition
| kbtshoot kbfirewall kbclient kberrmsg kbsecurity kbreplication kbservice kbserver kbdatabase kbprb KB842907 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
Anonymous User
- zidanwael NOSPAM-AT-NOSPAM yahoo.com
|
Reported as Irrelevant
|
| Written:
11/28/2004 9:24 AM |
|
|
|
wael
- zidanwael NOSPAM-AT-NOSPAM yahoo.com
|
Reported as Irrelevant
|
| Written:
11/29/2004 3:40 AM |
|
|
|
Star Brashear
- honeybun7 NOSPAM-AT-NOSPAM sbcglobal.net
|
Report As Irrelevant
|
| Written:
7/31/2005 2:29 PM |
|
|
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please