Microsoft SQL Server versions 2005, 2008 and 2008R2 are no longer supported in Automation Engine 18.0. Automation Engine has moved to SQL Server 2017 Express for its onboard SQL Server. This upgrade also required an update of the Microsoft SQL driver, and that driver no longer supports SQL Server 2008R2 (and older).
For local database servers (i.e. SQL Server and Automation Engine are on the same computer), the installer will detect an unsupported database and block the upgrade from continuing.
In case of a remote database server (SQL Server and Automation Engine are on a different computer), the installer is not able to detect an unsupported database, which may leave your system unsupported and broken (some components are known to be broken).
These unsupported databases are still quite common, because we shipped 2008R2 until version 14.0.1 (released in October 2014).
Automation Engine 12.0.0, 12.0.1 and 12.1.0 were shipped with Microsoft SQL Server 2005 Express.
Automation Engine 12.1.1, 12.2 and 14.0.x were shipped with Microsoft SQL Server 2008R2 Express.
Automation Engine 14.1.x, 16.0.x and 16.1.x were shipped with Microsoft SQL Server 2014 Express.
Note that this limitation also applies to so-called 'External Databases' (Tools, Configure, External Database) where the DBMS type is "Microsoft SQL Server". For these external databases, a workaround to still use an older version of SQL Server is described in KB194843345.
Follow the steps given below to upgrade to Automation Engine 18.0:
Check if the version of Microsoft SQL server is still compatible with Automation Engine 18.0 (SQL 2012 or newer are supported)
In the Automation Engine Pilot, go to Tools > Configure > Automation Engine Databases and check the hostname and instance of the configured SQL Server.
Then either with Microsoft SQL Studio Management Express or using Server Admin, SQL Server, check the version of SQL Server is at least SQL Server 2012 or newer.
If the installed version of SQL Server is 2005/2008/2008R2, proceed to step 2 to upgrade SQL Server 2005 to 2014 or 2017.
If the installed version of SQL Server is 2012 or newer, you can upgrade without problems to Automation Engine 18.0.
Upgrade Microsoft SQL Server 2005/2008 to SQL Server 2014 or 2017
Verify that the compatibility level is set to SQL 2005 (see KB105514234).
Stop the Automation Engine Server software on the Master.
Using Server Admin, make a full Backup, including the databases, make sure no errors occur when creating the backup.
Go to the Windows Services and stop the services: SQL Server (MSSQLSERVER) and if exists SQL Server (EG_APPSRV_JBOSS) too.
On the Automation Engine Master server, Go to Control panel and double click Program and Features.
Double click either Microsoft SQL Server 2005 or SQL Server 2008 (64bit) or SQL Server 2008 R2 (64 bit ). Select the MSSQLSERVER (the unnamed instance) and check the Workstation Components options and click Next to uninstall.
If there is a Microsoft SQL Server instance with the name EG_APPSRV_JBOSS (instance used by the EG Application Server), repeat the previous step but now select the instance EG_APPSRV_JBOSS and click Next to uninstall the named instance.
Check if there are other entries referring to Microsoft SQL Server 2005 in the Program and Features. If so, uninstall these as well.