Prev: Merge & DR
Next: Horizontal Filtering
From: T. Roemer T. on 8 Apr 2010 07:59
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




 | 
Pages: 1
Prev: Merge & DR
Next: Horizontal Filtering