On-Premise Adobe Connect Upgrade Fails to Fully Update the SQL Database
This article pertains only to on-premise Adobe Connect installations.
Note: This article contains images. You may need to refresh the WordPress page in your browser to view them.
With the deprecation of Adobe Connect 11, customers upgrading from 11.4.9 all the way to 12.7 will also be updating the SQL database that supports Adobe Connect. The upgrade process invokes multiple SQL update scripts. The installer is designed to upgrade the database as part of the normal upgrade process. There are 13 scripts that the installer runs to get from 11.4.9 to 12.7 to update the Connect database.
Most Adobe Connect on-premise installation and upgrade failures are caused by issues creating or updating the Adobe Connect Database; connectivity, permissions and compatibility levels can affect the installation process.
See the following articles for SQL permissions and connectivity issues:
- Using Windows Authentication AD Permissions for the Adobe Connect SQL Database
- SQL JDBC Connection Fails during Adobe Connect On-premise Server Installation
- Connect On-premise Server Upgrade Fails because of Encrypted SQL Connection
- Configuring Secure SQL with Connect
- Adobe Connect install fails with java.sql.SQLException
Any script that the installer runs automatically can be run manually directly on the SQL server. This is often a good remedy when connectivity and permissions levels are not in question, but a script fails. Before running any SQL scripts manually extracted the Adobe Connect installer, it is imperative to check the version of the DB by executing the query: select * from PPS_DATABASE_VERSION

The SQL update scripts are found in the installer under Merge_Modules:

Once you ascertain the version of the SQL DB supporting Connect, you can target the appropriate scripts to run manually in SQL Server Management Studio:

Note that if the installer failed to automatically run one or more scripts, you will want to make certain when running them manually they actually do succeed. Look for this at the bottom of the SQL Management Studio screen with each execution:

If any script fails then examine the error message to troubleshoot. See below that the compatibility level set for the Abode Connect (Breeze) database was set too low to allow this script to run. In the case of an upgrade from 11.x to 12.x, this could happen with select scripts if the installation being upgraded has been around a while and has a low compatibility level set in the database:

In this case noted above, the DB compatibility must be increased from 2012 to at least 2020 in order to succeed. Setting compatibility levels in SQL may require elevated permissions in a shared database environment and this should be considered prior to attempting any major upgrade window. See below how the option under Database Properties to change the compatibility level is greyed out. The Adobe Connect Admin performing the upgrade in this case lacks the permission on the shared SQL Server to change the compatibility level of the Adobe Connect database:

With elevated permission in SQL the task of raising the compatibility level is easy:


Or by script:

There are many variables that can affect the creation or update of the Adobe Connect Database. Simply searching on the Adobe Connect Support Blog using the string “SQL” will provide much valuable information: https://blogs.connectusers.com/connectsupport/?s=sql