[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 874
  • Last Modified:

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

Hello,

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.
0
devshed
Asked:
devshed
  • 2
  • 2
1 Solution
 
TempDBACommented:
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:-
http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/82a8c9c5-9b73-485b-8b2e-6b75c78ff86c
0
 
devshedAuthor Commented:
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! :(
0
 
TempDBACommented:
Happens :)
Thanks for sharing the solution..
0
 
devshedAuthor Commented:
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. :(
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now