How do I remove, uninstall, or stop using SQL Replicator?
Description

Note: Disabling the service for the SQL Server instance, instead of uninstalling it, may cause performance issues with other interfacing software or programs you use when it is syncing with Sage 300 CRE.

Cause
Resolution
[BCB:2:Database warning:ECB]
  1. Optional: Remove the SQL database(s) for the SQL server instance you use with SQL Replicator. For the removal process, refer to article 93215
    DocLink: Replicator: How do I remove an existing Sage 300 CRE replicated database in Microsoft SQL Management Studio so I can start over?
  2. Stop replicator from running
    Start > Search > System Administrator > log In > Select your replicated company > Stop Replicator
  3. Uninstall the SQL instance you were using for SQL Replicator. Consult with your database administrator and/or Microsoft for assistance.
    • Notes:
      • The default name is SAGE300CRE, but you may have chosen a different name upon installation.
      • Do not remove the shared features and components as it may affect other SQL instances you are using.

  4. Open Task Scheduler and delete any Replicator tasks under Sage 300 CRE.
    1. From the Windows Start menu, select All programs, Windows Administrative Tools, Task Scheduler.
    2. Expand Task Scheduler Library.
    3. Under Sage 300 CRE, delete all tasks.
  5. Delete the following files:
    1. Go to directory C:\ProgramData\Sage\TIMBERLINE OFFICE\9.5\ACCOUNTING\MISC
    2. Delete these two files: ReplicatorInstanceName.txt and xxx¦xxx¦ConnectionSettings.xml (The file name will start with machine name followed by the SQL instance name, for example: SERVERNAME¦SAGE300CRE¦ConnectionSettings.xml.)
DocLink: Replicator: How do I remove an existing Sage 300 CRE replicated database in Microsoft SQL Management Studio so I can start over?

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles