title: SQL Server Merge Replication fails with "Initializing SQL Server Reconciler has failed. Try again."
body: <p>I'm trying to set up replication between a SQL Server 2008 R2 database and SQL Server CE 3.5. I have set up IIS 7 accordingly and get a nice "Microsoft SQL Server Compact Server Agent" when checking the publication URL (<a href="http://winserver2008/SQLReplication/sqlcesa35.dll" rel="nofollow noreferrer">http://winserver2008/SQLReplication/sqlcesa35.dll</a>).</p>
  
  <p>However when I try <a href="http://winserver2008/SQLReplication/sqlcesa35.dll?diag" rel="nofollow noreferrer">http://winserver2008/SQLReplication/sqlcesa35.dll?diag</a> I get the following:</p>
  
  <p><img src="https://i.stack.imgur.com/6SJPJ.png" alt="enter image description here"></p>
  
  <p>When I try to connect to the publisher via a C# app I'm writing I get "Initializing SQL Server Reconciler has failed. Try again". i assume that means I need that 9.0 database reconciler? If so how do I install it?</p>
  
  <p>On a side note this only happens when I try to connect via Integrated Windows Authentication. If I try via SQL Server authentication instead I just get an error about SQL Server missing or having an incorrect login/password.</p>