Manually Configuring IIS
The connectivity support and security options for Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) 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:
Create a virtual directory by using IIS:
Specify an alias name for the virtual directory.
Specify the location for the content folder for the virtual directory. A copy of the SQL Server Compact Edition Server Agent (Sqlcesa30.dll) must reside in this directory. By default, the SQL Server Compact Edition Server Agent is installed in C:\Program Files\Microsoft SQL Server Compact Edition 3.0\Server.
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 Edition Server Agent (Sqlcesa30.dll) filename. For example, the following URL accesses SQL Server Compact Edition Server Agent in a virtual directory names "sqlce": https://www.adventure-works.com/sqlce/Sqlcesa30.dll
Specify the Execute access permission for the virtual directory.
For more information, see Virtual Directory Information (SQL Server Compact Edition).Note
For IIS 6.0, you add the SQL Server Compact Edition Server Agent as a Web Service Extension and set it to Allowed.
Register sqlcerp30.dll in the IIS virtual directory. To register the sqlcerp30.dll, open the command prompt and type regsvr32 "C:\Program Files\Microsoft SQL Server CE 3.0\Server\sscerp30.dll".
Configure IIS authentication by using IIS. Modify the properties of the virtual directory that you created in step 1. SQL Server Compact Edition supports three authentication options:
- Anonymous access
- Basic authentication
- Integrated Windows Authentication
For more information, see Virtual Directory Information.
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 Edition replication or RDA works with a FAT file system, but we recommend that you use NTFS file system.
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
Configure SQL Server Compact Edition 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 Sqlcesa30.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