Merge replication fails with HTTP header information corrupted or it is missing in the transport message.

Posted on 2012-08-31
Last Modified: 2013-12-27

I am migrating my existing system (merge replication application) from MSSQL 2K and SQLCE 2.0 on a single server to a MSSQL 2K8 R2 and SQLCE 3.5 on a two server setup (IIS on one box and SQL on another).

My issue is that I keep getting the following error in my merge replication log (i changed the error logging level to 3):

Hr=80070585 ERR:Failure reading Transport version header 0

Also, a few days ago the merge replication would work but it would take about 1,5 hour to complete, whereas the existing (old) system completes it in about 7-8 minutes.

Can you please help?

Thank you for your help.
Question by:devshed
    LVL 25

    Expert Comment

    I have never seen the error before. But on googling, I found something related. You can ask if the user got any reply in the post:-

    Accepted Solution

    Hi TempDBA,

    Thank you for your prompt response...

    I found the root of my problem...For some silly reason, I had not changed the Merge Replication Internet URL to point to the (new) SQLCE 3.5 instance. It was pointing to the (old) SQLCE 2.0 instance, hence it was not working! :(
    LVL 25

    Expert Comment

    Happens :)
    Thanks for sharing the solution..

    Author Closing Comment

    I found out that I used the wrong URL...I was trying to Merge Replicate my SQLCE 3.5 client database to an SQLCE 2.0 instance on my SQL server. :(

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now