Precedents

1. Windows 2000 Server
2. 1 SERVERNAME
   SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
   Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
3. 1 SERVERNAME\INSTANCE
   SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
   Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)
4. IIS 5.0
5. SQL Server CE 2.0 (sp3a)
6. Merge replication previously working fine.

The problem

After migrating MSDE from sp3a to sp4 (in order to fix CE replication bug) I can't sync to MSDE.

I got the following error code: [29045]->[Initializing SQL Server Reconciler has failed.] so I've looked into SQL Server CE log file and I've found the following error message:

2006/02/07 19:44:23 Thread=9A8 RSCB=4 Command=SYNC Hr=00000000
The process could not connect to Distributor 'Distributor-name'. 20084

2006/02/07 19:44:23 Thread=9A8 RSCB=4 Command=SYNC Hr=00000000
Data source name not found and no default driver specified

I've already tried without success

Uninstalling all SQL Server 2000 (EE) instances (except for the "no instance")
Unistalling and re-install MSDE (sp4)
Re-registering sscerp20.dll.
Rebooting server.
Restarting IIS.

Any ideas?

Sebastian

Sebastian,

I seem to remember that someone else asked this question over in the public newsgroup (microsoft.public.sqlserver.ce) and the answer was that the replication tools for SP4 did not support MSDE. Perhaps Laxmi can clarify this? Sorry I don't have a more definitive answer for you.

-Darren

Sebastian - just checking in with you to make sure you got past this issue. Let us know if we can help further.

-Darren