Remove Application Database from SQL and SSAS Server

Author: Kepion Product Team

Introduction

In this article we'll look at Removing an Application Database from your environment. This will involve clearing the Database from both your SQL and SSAS servers.

SQL Server

Open Microsoft SQL Server Management Studio and connect to your SQL Server instance. Expand Databases, and right-click on CPMAppHost. Select Delete.

Check the box next to Close Existing Connections and click OK.

Note: Repeat this step for the application backup and other databases that are associated with Kepion.

SSAS Server

Next, proceed to the Analysis Services from the Connect menu. Expand the Databases and right-click on the application. Select Delete.

In the Delete Objects window, select OK.

Note: Repeat this step for other databases that are associated with Kepion.