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

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 ("proxy authentication required") 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.

REFERENCES

For more information, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_errors_replication_transport_errors.asp

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

313685 NTLM proxy authentication does not work from Pocket Internet Explorer