SQL Server CE Replication application fails with error message 29045 (814853)


The information in this article applies to:

  • Microsoft SQL Server 2000 Windows CE Edition 2.0
  • Microsoft SQL Server 2000 Windows CE Edition 1.1
  • Microsoft SQL Server 2000 Windows CE Edition

SYMPTOMS

When you run an application that uses SQL Server CE replication, the application may fail and you receive the following error message:

29045: Initializing SQL Server Reconciler has failed.

CAUSE

The DLL file that corresponds to the SQL Server CE Replication provider is not registered on the computer where SQL Server CE Server Tools is installed.

RESOLUTION

To resolve the problem, register the SQL Server CE Replication Provider DLL on the computer where SQL Server CE Server Tools is installed. To do so, follow these steps:
  1. Open a command prompt.
  2. Run the following command:

    regsvr32 "Full path of DLL file"
Note Here is the list of the DLL file names that correspond to the SQL Server Replication provider in SQL Server CE 1.0, SQL Server CE 1.1,SQL Server CE 2.0:
  • Sscerp10.dll for SQL Server 2000 Windows CE Edition 1.0
  • Sscerp10.dll for SQL Server 2000 Windows CE Edition 1.1
  • Sscerp20.dll for SQL Server 2000 Windows CE Edition 2.0

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

279123 FIX: SQL Server 2000 Uninstallation May Break SQL Server CE Replication

Modification Type:MinorLast Reviewed:9/20/2005
Keywords:kbRegistry kbDLL kberrmsg kbprb KB814853 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.