Post Uninstall Cleanup: CAM Database and SQL Server Instance

You'll need to remove the CAM database and the SQL Server instance if you want to completely uninstall Cherwell Asset Management.

Removing the CAM Database

The uninstall process removes CAM components that communicate with the CAM database, but does not delete the CAM database from the SQL Server on which it is installed. This behavior is intentional, so that you can move components without risking loss of CAM data.

Cherwell recommends that you back up your CAM database before removing it.

To remove the CAM database and CAM user login on the SQL Server:

  1. Verify that no processes are currently using the CAM database; that is, all CAM server components are removed and no other SQL applications (such as SQL Management Studio) are connected to your CAM database.
  2. To remove the CAM database, issue the following command:
    Do not use quotation marks with this command.
  3. To remove the CAM user login, issue the following command:
    EXEC sp_droplogin 'CAM'

    Where 'CAM' (single quotation marks required) is the name of the CAM account created when you installed Cherwell Asset Management.

The above procedure removes the CAM database from the SQL Server, but not the database files; you have to manually delete the files if you no longer need them.

Removing an SQL Server Instance

To uninstall an instance of SQL Server that you created when you installed Cherwell Asset Management, use the standard Windows Control Panel method as if you were planning to uninstall SQL Server, and select the instance to remove.

Removing SQL Server Express

If you installed SQL Server Express Edition as part of your CAM installation, you can remove it through the standard Windows Control Panel method. SQL Server installs several components separately; you'll need to remove all of them to completely uninstall SQL Server.