Hi
I've been trying to follow the guide here: http://msdn.microsoft.com/en-us/library/bb226707.aspx to configure IIS for Merge replication with SQL Server 2005 CE.
I've had several problems when using ConnWiz30.exe. I'm using IIS7 on Vista, and I have selected all options except "Application Development Features" when turning IIS on in Vista.
The How-To instructs you to set up new a virtual directory during the process, however I have not been able to do that because in the guide To configure IIS for SQL Server Compact Edition synchronization > Point 14 I get the error "The program cannot open the required dialog box because no locations can be found. Close this message, and try again."
I can get around this problem by creating a new virtual directory using IIS Manager first. When I do that and click "Test Connection" I get a warning "Cannot Verify Access to path (C:\inetpub\wwwroot\MyDir)." with the details...
The server is configured to use pass-through authentication with a built-in account to access the specified physical path. However, IIS Manager cannot verify whether the built-in account has access. Make sure that the application pool identity has Read access to the physical path. If this server is joined to a domain, and the application pool identity is NetworkService or LocalSystem, verify that <domain>\<computer_name>$ has Read access to the physical path. Then test these settings again.
However if I click "Connect As" and enter AdministratorUsername/AdministratorPassword the warning goes and the test connection works fine.
Then, I can complete the How-To by selecting the existing directory, which is adds IUSER by default. The problem then is that when i navigate to http://localhost/Sync/sqlcesa30.dll as the guide says to, to check the IIS config, instead of getting the message indicated in the How-To I get a File Download dialog box, so it appears IIS is not configured correctly.
Any help is greatly appreciated.
Thanks!