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.
To remove the CAM database and CAM user login on the SQL Server:
- 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.
- To remove the
issue the following command:
DROP DATABASE CAMDBDo not use quotation marks with this command.
- To remove the
user login, issue the following command:
EXEC sp_droplogin 'CAM'
'CAM'(single quotation marks required) is the name of the CAM account created when you installed Cherwell Asset Management.
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.