While developing a Windows Mobile device application on two different computers, I thought I’d installed SQL Server Compact Edition 3.5 SP2 on both of them, but ran into some version difference issues. Here’s a shot of the screen where I had to make this change, in case there’s any confusion:Īuthor Ryan McCauley Posted on MaApCategories SQL Compact, SQL Server Tags replication, sql compact, Updates Leave a comment on “Initializing Reconciler has failed” when setting up SQL Compact replication Matching up SQL CE DLL version numbers Add the user you’re connecting your subscriber with to this list.Select “Properties” and then open the “Publication Access List” tab.In SQL Management Studio, right-click the publication.At some point, I’d changed the user I was using to set up the subscription, and that user didn’t have rights to view the publication list on my SQL Server. Sure enough, executing that command in SSMS, logged in as my replication user, gave me the same error message. The remote server “SQLSERVERNAME” does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers. Searching for the error online comes back with a dozen recommendations, but when I traced the replication sync attempt, I saw the following statement executed:Įxec sp_helpdistpublisher N’SQLSERVERNAME’įollowed immediately by the error message: I had confirmed that SQL Compact web replication was set up correctly, and checking the URL came back as expected. Initializing the SQL Server Reconciler has failed. NET Compact Framework client on a mobile device, I was receiving an error message when I attempted to start the synchronize: