Microsoft KB Archive/837390

= FIX: An exception occurs when you run a SQL Server CE RDA application that tries to connect to the SQL Server CE Server Agent by using an HTTPS connection =

Article ID: 837390

Article Last Modified on 2/13/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition

-



BUG #: 9100 (SSCE)



SYMPTOMS
When you run a Microsoft SQL Server 2000 Windows CE Edition Remote Data Access (RDA) application that tries to connect to the SQL Server CE Server Agent by using an HTTPS connection, you may receive an exception, such as a System.Data.SqlServerCe.SqlCeException exception. This problem occurs if all the following are true:
 * The RDA application runs on a Microsoft Pocket PC 2003 device or a Microsoft Pocket PC 2003 emulator.
 * The RDA application connects to the SQL Server CE Server Agent by using a Microsoft Internet Security and Acceleration (ISA) Server proxy server.
 * The ISA Server proxy server that the RDA application uses to connect to the SQL Server CE Server Agent requires Basic authentication.

This problem occurs because of a SSCE_M_HTTPSTATUSPROXYAUTHREQ error. Therefore, if you include error handling code in the RDA application, you receive an error message that is similar to the following:

Error Code: 80070057

Message: Authentication failed on the proxy server

Minor Err.: 28012

Source: Microsoft SQL Server 2000 Windows CE Edition

This problem occurs even if you provide valid credentials to authenticate the ISA Server proxy server. Additionally, the exception occurs only the first time that you run the RDA application to connect to the SQL Server CE Server Agent by using an HTTPS connection through an ISA Server proxy server.



CAUSE
The SQL Server CE RDA client sends the Basic authentication information to an ISA Server proxy server only when the ISA Server proxy server sends the 407 (&quot;proxy authentication required&quot;) response to the SQL Server CE RDA client. However, because of a problem in the Wininet library, the authentication fails even if the Basic authentication information is valid.



RESOLUTION
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.   Date        Time    Version            Size    File name           Platform 10-Mar-2004 06:21                      6,656  Calog20.exe         ARM 10-Feb-2004 10:07  2.0.6210.0      1,377,792  Ssce20.dll          ARM 10-Mar-2004 06:17  2.0.6310.0        264,192  Ssceca20.dll        ARM 15-Aug-2002 18:54  2.0.4415.0         70,144  Ssceerror20en.dll   ARM

Note Because of file dependencies, the most recent hotfix or feature that contains the files in this table may also contain additional files.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
This problem occurs when the RDA application sends an HTTPS request through an ISA Server proxy server to access the SQL Server CE Server Agent. However, this problem may not occur if the RDA application sends an HTTP request through an ISA Server proxy server to access the SQL Server CE Server Agent.

