SQL Mirroring not Failing over as expected

Version 1

    Verified Product Versions

    AppSense Environment Manager 10.0AppSense Management Center 10.0AppSense Environment Manager 8.6AppSense Management Center 8.6AppSense Management Center 8.7

    Introduction

    If SQL Mirroring has been configured as per our Best Practices and you find SQL Mirroring is not failing over to the Failover Partner as expected this could be due to the Failover Partner being incorrectly listed in the Environment Manager and Management Center configuration files.

    The SQL Mirroring best practises can be found in the Installation and Upgrade guides for Environment Manager and Management Center.

    Detail

    Since AppSense Environment Manager 8FR5 and AppSense Mangement Server 8FR5 the Connection String used to define the SQL Failover Partner, found in the configuration files became encrypted, because of this it is not advisable to modify these files in plain text. Doing so may cause the Failover partner to be unrecognised or duplicated.

    Once the best practices have been implemented, the AppSense Server Configuration Utlity API can be used to set the Failover Partner for Environment Manager Personalization or Management Center using Powershell. Please run the following commands to configure the Failover Partner.

    CAUTION: Powershell must be ran as an Administrator on the local Personalizaion or Management Server

    Personalization Server.
    - Run the following cmd-lets replacing the Server\Instance with the details for your failover server

    Import-ApsInstanceModule -ProductName "Personalization Server"
    $ConnectionString = "Failover Partner=Server\Instance"
    Set-ApsServerDatabase -ConnectionString $ConnectionString
    Management Server.
    - Run the following cmd-lets replacing the Server\Instance with the details for your failover server

    Import-ApsInstanceModule -ProductName "Management Server"
    $ConnectionString = "Failover Partner=Server\Instance"
    Set-ApsServerDatabase -ConnectionString $ConnectionString