Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx.

I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1.

Entering http://localhost/SQLMobile/sqlcesa30.dll?diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics,

SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x80004005

SQL Server Module Versions Module Version sqloledb.dll 2000.85.1117.0 9.0 replrec.dll 2005.90.3033.0 9.0 replprov.dll 2005.90.3033.0 9.0 msgprox.dll 2005.90.3033.0

I managed to solve all problems except one, occuring at the ending of the tutorial: Create a new subscription. When I'm trying to subscribe on created CE database I get the following error (at the second step of creating subscription):

Internal error: HTTP header information is either corrupted or missing in the transport message. It could be a network transmission error or an IIS problem.
HRESULT 0x80072F76 (28035)

I tried to google for it but only one result, with no solution.

Anybody has an idea what's wrong? I can provide further configuration details as necessary.

Thanks in advance

Cachotterie

I'm getting the same problem. Am running off a loopback adapter. Did you ever manage tot resolve this issue?|||In my case it was just Norton Internet Security firewall somehow modifying HTTP headers. I didn't find a way to make it work - just uninstalled it and now it is fine.|||

Have you solved this problem? I’m facing the same issue.

Thanks!

Eva

|||

I have this issue too ... and when I disable 'all of' Norton Security then the issue disappears.

For me it occurs in doing the tutorial: "Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual C#.NET" at http://msdn2.microsoft.com/en-us/library/bb259792.aspx

With Norton Security active, whenever the tutorial code executes rda.Pull(...), I get the error message:

"Internal error: HTTP header information is either corrupted or missing in the transport message. ..."

The trouble is I can't work out what I need to adjust in Norton Security so that I can leave security active.

Any help will be greately appreciated. Cheers, Henk.

|||For all those finding themselves in this predicament, we found a solution for this problem with regards to the Norton Internet Security/Firewall issue.

As with other posters, we had a problem running SQL Server Merge Replication between the SQL Server CE clients and the SQL Server 2005 servers when the firewall was enabled. Disabled, it would run fine. The solution we came up with was to place the IP address or the entire subnet in some cases for the SQL Server 2005 servers into the Trusted Zones of the client firewall(s). This was accomplished here via Group Policy, but could be done on a case by case basis jus the same.

Hopefully this remedies someone elses heartache down the road. It was certainly frustrating for me.

Good luck!

-Patrick