Can't Initiate JCMA - JCMA Connection Failure - Error Communicating with Server

Issue Summary

The user is unable to activate and then launch JCMA as the error message pops up with this message -  Connection Failure - Error Communicating with Server.  
As per the log file, the following error appears in the log file when Jira DB is hosted on Microsoft SQLServer instance.  There appears to be a missing schema for AO tables.
 

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'null.AO_6FF49D_MIGRATION_ENTITY'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:256)  

Steps to Reproduce

1. Attempt to Activate JCMA under Manage Apps

Expected Results

The user should be able to activate JCMA

Actual Results

Connection Failure - Error Communicating with Server.  

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'null.AO_6FF49D_MIGRATION_ENTITY'.     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:256)   

Workaround

Advised the user to change the schema for AO tables using this article here

1. Shutdown JIRA
2. Run the following SQL query in SQL Server:

   SELECT 'ALTER SCHEMA newschema TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'oldschema'

1. 1. Replace newschema and oldschema with the actual names of your new and old schema.
   2. This essentially provides a list of SQL queries to help automate the ALTER SCHEMA function in SQL Server
2. Copy the results into a new SQL script and run the queries.
3. Define the new schema in dbconfig.xml: JIRA Home Directory
4. Restart JIRA