Issues with Websynchronisation

[Roemer@discussions.microsoft.com T. Roemer]

Our Server:
- Windows Server 2008 Web Edition R2 x64
- MS SQL Server 2008 Standard Edition SP1 x64
- IIS 7.5

PDAs:
- SQL Server Compact Edition 3.5
- WindowsMmobile Professional 6.5

Goal:
We have a database and want to establish a mergereplication between the SQL
Server 2008 Standard Edition (as publisher) and several PDAs with a SQL
Server Compact Edition 3.5 Database.
But we have problems getting the Websynchronisation working.

The steps we performed (we run the SQL Server Management Studio as
Administrator):

1. Setting up our Database
2. we set up a new publication with the wizard (everything was executed
successfully is displayed in the final wizard window)
3. we used the wizard to set up the Websynchronisation. (everything was
executed successfully is displayed in the final wizard window)

But it seems that the wizard doesn't set all permissions/settings correctly:

- The virtual directory is configured as a web application and not
as a virtual directory. You can see this in the IIS7.5 Manager (and if you
try to connect to the dll in a browser procmon shows that the w3wp.exe
tries to open "C:\Program Files (x86)\Microsoft SQL Server Compact
Edition\v3.5\sync\SQL\test5\sqlcesa35.dll\web.config" which obviously does
not exist)

When we try to open https://COMPUTERNAME/VIRTUALDIRECTORY/sqlcesa35.dll on
our Server we get a
-----------------------------------------------------------------------
HTTP-Fehler 500.0 - Internal Server Error.

Modul

IsapiModule

Benachrichtigung

ExecuteRequestHandler

Handler

ISAPI-dll

Fehlercode

0x800700c1

Angeforderte URL

https://COMPUTERNAME/test5/sqlcesa35.dll

Physikalischer Pfad

C:\Program Files (x86)\Microsoft SQL Server Compact
Edition\v3.5\sync\SQL\test5\sqlcesa35.dll

Anmeldemethode

Anonym

Angemeldeter Benutzer

Anonym
-----------------------------------------------------------------------

Things we tried to fix the problem:
- we run the SQL Server Management Studio "as Administrator" and as a
normal user

- we checked the permissions of the snapshotfolder (IUSR has full
access)

- we checked the permissions of the virtual directory (IUSR has
full access)

- we added the sqlcesa35.dll to the ISAPI filter list

- we tried "NetworkService" and "ApplicationPoolIdentity" as
identity of the defaultapplicationpool

- we used the web synchronization wizard to create the virtual
directory in the SQL Server CE directory

- we used the web synchronization wizard to create the virtual
directory in the "inetpub/wwwroot" directory

- we used the web synchronization wizard to create the virtual
directory somewhere else on the systemdrive

- we tried to setup the virtual directory without the wizard

- we tried what is described in the last 2 post here:
http://ask.sqlservercentral.com/questions/3591/configuring-web-synchronization-on-windows-7-ultimate-x64/

- we disabled/enabled the firewall

Questions:
- Is this a known problem or is there something specific with our software
setup that we need to adjust in order to get it working?

- I also read that the combination of SQL Server and IIS 7.5 is not
supported by Microsoft to be used for websynchronisation but couldn't find
any proof. Does anybody know anything about this ?

PS:
We already got this working with:
Windows Server 2003 Standard Edition SP2, MS SQL Server 2005 Standard
Edition, IIS6, SQL Server Compact Edition 3.1, Windows Mobile Professional
6.1

[ErikEJ]

You must:

Using IIS manager:
- Add Role Services: "IIS 6 Managment Compatibility" and "ISAPI Extensions"
- Add Execute permission to ISAPI-dll feature.

- Install the SQL Compact 3.5 SP1 server tools
- Run connwiz.exe as administrator
- and this:
http://erikej.blogspot.com/2010/01/iis-75-windows-server-2008-r2-and-sql.html

Hope this helps.

--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

"T. Roemer" <T. Roe...@discussions.microsoft.com> wrote in message
news:EEF6D13B-F111-46B7...@microsoft.com...