I am trying to configure a SQL 2008 merge publication for Web Synchronization on IIS 7.5 which is running on a Windows 7 Ultimate (x64) box. I have done this many times using IIS 6 without a problem, but IIS 7.5 is not so forgiving. My goal is to have a Pocket PC connect anonymously and synchronize a database using a merge pull subscription.
I have installed all of the IIS 6 compatibility modules and all of my attempts to run the Web Synchronization Wizard were done as an Administrator using elevated priv's. The wizard completed its task without any errors.
The problem comes when I try to confirm the web site is working by loading http://ssc/efinity_pub/sqlcesa35.dll into IE. Whether I do it from the same machine running IIS or from a Pocket PC that is connected to that computer, I get an HTTP error 500.19. I have faithfully reproduced this on two Windows 7 boxes on two totally separate networks.
If I change the DefaultAppPool Identity from ApplicationPoolIdentity to NetworkService as I found suggested on one internet site, The error changes to 401.2. One way or another, I run into some kind of permissions error.
Any help would be greatly appreciated.