It works with ActiveSync, but not with TCP/IP ?

[Dany Lauener via .NET 247]

Hello,

I've had the same problem with a SQLCe merge replication.
I can perhaps help with some more details.

The replication works well with an ActiveSync connection but not with a TCP/IP only connection.

Something strange : when the replication was done successfully with ActiveSync, then the sychronization works well with TCP/IP connection.

The errors 28557 (80004005) followed by 28037 (80072EE2) happen when there is no valid database on the CE device before sychronization.

I've make it work with a workstation running Windows XP SP2.

The following service are runnnig:
- HTTP SSL (I think a secure connection is required)
- remote Access Connection Manager

And I've made the following changes :
- Install a "Microsoft Loopback" connection
- Bridge the Loopback connection with the network connection
- setup firewall settings to grant HTTP and HTTPS
- install a bug fix because I have indexed views (http://support.microsoft.com/?id=816780)

Well, I've made so much changes now that I'm not sure why it works....

Ah, another detail :
I access the server with an IP address, not a DNS name.

Cheers
Dany