Microsoft KB Archive/310654

= IIS Lock Down Tool may break RDA or Replication that uses Anonymous authentication =

Article ID: 310654

Article Last Modified on 2/22/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 2005 Compact Edition

-



This article was previously published under Q310654



SYMPTOMS
If you install the Microsoft Internet Information Server (IIS) Lock Down Tool with all the default options, it may break a working Microsoft SQL Server 2000 Windows CE (SQL Server CE) or Microsoft SQL Server 2005 Compact Edition Remote Data Access (RDA) or Replication application that uses Anonymous authentication.



CAUSE
The default Setup of the IIS Lock Down Tool sets the following option:

&quot;Set file permissions to prevent anonymous IIS users from writing to content directories.&quot;

SQL Server CE or SQL Server Compact Edition Replication and RDA rely on three modes of IIS authentication:
 * Anonymous authentication
 * HTTP Basic authentication
 * Integrated Windows authentication



RESOLUTION
To resolve this problem:  If you use SQL Server CE connectivity applications or SQL Server Compact Edition applications that use Anonymous authentication, clear this default option:

&quot;Set file permissions to prevent anonymous IIS users from writing to content directories.&quot;

Otherwise the application may not run.

-or-

 You can reconfigure SQL Server CE connectivity applications or SQL Server Compact Edition applications to use Basic or Integrated Windows authentication, not Anonymous, to run the tool.



MORE INFORMATION
SQL Server CE RDA and replication components communicate by using Web protocols. The SQL Server CE Client Agent on the Windows CE device uses HTTP to communicate with the SQL Server CE Server Agent ISAPI DLL on the Web server.

Steps to reproduce the problem
To reproduce the problem, use these steps:  Set up the SQL Server CE Northwind_RDA sample as described in SQL Server CE 2000 Books Online. Run the setup for the IIS Lock Down tool. Click to select SERVER TEMPLATE (click Other Server).</li> Click to select WEB SERVICE (HTTP).</li> Select Scripts maps (disable all support).</li> Click to select Additional Security (default).</li> Clear this option:

&quot;Set file permissions to prevent anonymous IIS users from writing to content directories.&quot;

</li> Click to select Install URL scan filter.</li> Run the SQL Server CE Northwind_RDA application and note that it still works ok.</li> Run the IIS Lock Down setup again to undo the previous installation. Run the setup to keep the default option:

&quot;Set file permissions to prevent anonymous IIS users from writing to content directories.&quot;

The SQL Server CE Northwind_RDA application fails with a 80070005 error message.</li></ol>

<div class="references_section">