I configured merge replication using SQL Server 2005 SP3 running on Windows Server 2008 R2 x64 with IIS 7.
My client is a .NET Compact 3.5 (RTM) application running on an embedded controller (Beckhoff CX1000) with Windows CE 6.0 installed. I am using SQL Compact 3.5 SP1 on the client. The preconfigured Win CE only had .NET Compact 2.0 installed, so I installed
version 3.5 on the CompactFlash card attached to the controller.
Syncing over HTTP works perfecly using anonymous authentication.
I then executed the Web Sync Config Wizard and configured Basic Authentication without SSL. For authentication I use a local account even though my server is a member of our domain. The same account is used for access to the publication and distribution
DBs (all located on the same server running IIS).
When I ran my client trying to sync, all I get is the 28011 error (Authentication failed).
The strange thing is that a test application on my desktop machine using .NET 3.5 (not Compact) can sync without problems. I even wrote a little test application for the embedded controller using the .NET HttpWebRequest object to connect to the server and
I get the expected "Microsoft SQL Server Compact Server Agent" message.
I dug a little deeper into the issue and analyzed the HTTP packet getting sent to the server (using Wireshark). App
View Complete Post