SQL Server Merge Replication fails with "Initializing SQL Server Reconciler has failed. Try again."
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 (http://winserver2008/SQLReplication/sqlcesa35.dll).

However when I try http://winserver2008/SQLReplication/sqlcesa35.dll?diag I get the following:

![enter image description here][1]

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?

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.

  [1]: http://i.stack.imgur.com/6SJPJ.png
SQL Server Merge Replication fails with "Initializing SQL Server Reconciler has failed. Try again."
===

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 (http://winserver2008/SQLReplication/sqlcesa35.dll).

However when I try http://winserver2008/SQLReplication/sqlcesa35.dll?diag I get the following:

![enter image description here][1]

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?

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.

  [1]: http://i.stack.imgur.com/6SJPJ.png