Manually Configuring IIS

  • Article

The connectivity support and security options for Microsoft SQL Server Compact 3.5 (SQL Server Compact 3.5) that are set by using the Configure Web Synchronization Wizard can also be configured manually. The following is a brief summary of the minimum configuration sets that are required to use replication or remote data access (RDA).

Configuring IIS Manually for Replication and RDA

Configuring Microsoft Internet Information Services (IIS) for either replication or RDA involves the following steps:

  1. Create a virtual directory by using IIS:

    1. Specify an alias name for the virtual directory.

    2. Specify the location for the content folder for the virtual directory. A copy of the SQL Server Compact 3.5 Server Agent (Sqlcesa35.dll) must reside in this directory. By default, the SQL Server Compact 3.5 Server Agent is installed in %Program Files%\Microsoft SQL Server Compact Edition\v3.5\sync\SQL.

      Note

      The name of the computer that is running IIS and the virtual directory must be specified as part of the InternetURL property. Optionally, you can include the SQL Server Compact 3.5 Server Agent (Sqlcesa35.dll) filename. For example, the following URL accesses SQL Server Compact 3.5 Server Agent in a virtual directory names "sqlce": https://www.adventure-works.com/sqlce/Sqlcesa35.dll

    3. Specify the Execute access permission for the virtual directory.
      For more information, see Virtual Directory Information (SQL Server Compact).

      Note

      For IIS 6.0, you add the SQL Server Compact 3.5 Server Agent as a Web Service Extension and set it to Allowed.

    4. Register sqlcerp35.dll in the IIS virtual directory. To register the sqlcerp35.dll, open the command prompt and type regsvr32 "%Program Files%\Microsoft SQL Server Compact Edition\v3.5\sync\SQL\sscerp35.dll". l".

  2. Configure IIS authentication by using IIS. Modify the properties of the virtual directory that you created in step 1. SQL Server Compact 3.5 supports three authentication options:

    • Anonymous access
    • Basic authentication
    • Integrated Windows Authentication

    For more information, see Virtual Directory Information.

  3. Configure IIS authorization using Windows Explorer.

    Note

    If the computer that is running IIS has a FAT file system, you can skip this step. SQL Server Compact 3.5 replication or RDA works with a FAT file system, but we recommend that you use NTFS file system.

    1. Configure directory authorization by navigating to the content folder you specified when you configured the IIS virtual directory. Add the following NTFS permission on the folder.

      User Required permissions

      For Anonymous access, grant permissions to the computername\IUSR_computername or the configured IIS anonymous user account.

      Read and Write

      For Basic or Integrated Windows Authentication, grant permissions to the client user or group.

      Read and Write

    2. Configure SQL Server Compact 3.5 Server Agent authorization by navigating to the content folder you specified when you configured the IIS virtual directory, and then add the following NTFS permission on Sqlcesa35.dll.

      User Required permissions

      For Anonymous access, grant permissions to the computername\IUSR_computername or the configured IIS anonymous user account.

      Read and Execute

      For Basic or Integrated Windows Authentication, grant permissions to the client user or group.

      Read and Execute