Removing a database connection which is 'stuck' in the SCP

Version 1

    Verified Product Versions

    AppSense Management Center 10.0AppSense Management Center 10.1

    Introduction

    If you cannot remove a database connection (EM Personalization Server or Management Server) from the SCP you may need to use a Powershell command to achieve it. The way to do this is detailed below.

    This method can also be used as part of a script or as a quicker way to remove a connection.

    Detail

    Run Powershell as an administrator, then use the following commands. You need to ensure you use the correct command to delete either a Personalization or Management Center database connection.

    NOTE: In the examples below the name of the connection is within the quotation marks, you will need to substitute your own name here (this is not the database name but the connection name)

    Remove Personalization Server database connection:

    Import-Module AppSense.ServerConfigurationPortal.PowerShell
    Remove-ApsDatabaseConnection -DatabaseConnection "Personalization Server connection" -Type Personalization
    Remove Management Center database connection:
    Import-Module AppSense.ServerConfigurationPortal.PowerShell
    Remove-ApsDatabaseConnection -DatabaseConnection "Management Server connection" -Type Management

    NOTE: If the above command fails to remove the connection you may need to reset the server to factory defaults. See the following article for instructions: http://www.appsense.com/kb/160826003917300