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

Article translations Article translations
Article ID: 279123 - View products that this article applies to.
This article was previously published under Q279123
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 350879 (SHILOH_BUGS)
Expand all | Collapse all

On This Page

SYMPTOMS

After you remove and reinstall SQL Server 2000 on a computer on which the SQL Server CE Server Tools are installed, you may experience the following error on the device if you try to use SQL Server CE replication:
Source: Merge Process
Error number: 8004505B
Description: The process could not load the Merge Replication Provider for 'SSCE'. Check to see if the component is registered correctly.

CAUSE

SQL Server 2000 uninstallation unregisters Sscerp10.dll, which is needed for SQL Server CE replication to work.
NOTE: If there are multiple instances of SQL Server 2000 on a computer, removing one of these installation will not cause this problem.

RESOLUTION

To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

WORKAROUND

To work around this problem, use REGSVR32 to reregister Sscerp10.dll on the computer where SQL Server CE Server Tools was installed, and then perform the synchronization again. (This .dll file is usually found in the Program Files\Microsoft SQL Server CE\Server folder.)

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in SQL Server 2000 Service Pack 1.

MORE INFORMATION

Steps to Reproduce the Problem

  1. Install SQL Server 2000 (Developer Edition).
  2. On the same computer, install SQL Server 2000 CE Edition and choose Server Tools.
  3. Uninstall SQL Server 2000 (Developer Edition).
  4. Optional: Re-install SQL Server 2000; this step makes no difference.
  5. Attempt to do replication with SQL Server CE and SQL Server 2000. You will receive the following error message:
    Source: Merge Process
    Error number: 8004505B
    Description: The process could not load the Merge Replication Provider for 'SSCE'. Check to see if the component is registered correctly.
If you reregister Sscerp10.dll on the SQL Server 2000 computer, the error does not occur and the synchronization is successful.

Properties

Article ID: 279123 - Last Review: February 28, 2014 - Revision: 3.3
APPLIES TO
  • Microsoft SQL Server 2000 Windows CE Edition
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB279123

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com