Microsoft® has declared that extended support for Microsoft® SQL Server 2014 will cease after July 9, 2024. Consequently, Act! versions that depend on that version of SQL will no longer receive crucial security updates post-July, posing a heightened risk of security vulnerabilities for systems and applications. Running an unsupported database can also lead to compliance problems for those in industries like health, financial, mortgage, insurance, or public sector organizations governed by regulatory security requirements.

It is also worth noting that SQL Server 2014 and SQL 2016 are incompatible with Windows 11, rendering Act! versions 20 -23 are uninstallable on most contemporary computers.

We make the following recommendations for these common Acts for these reasons and others! installation scenarios:

1. Users with Act! v20 - Act! v23 that are fitted with SQL 2014
   1. Upgrade to SQL Express 2016 (supported until July 2026) - How to Upgrade SQL Server 2014 to SQL Server 2016 
      
   2. Purchase Extended Security Updates: If immediate migration or upgrade isn’t feasible, consider purchasing Extended Security Updates from Microsoft to continue receiving security patches.
   3. Upgrade to supported versions of Act!, namely v24 or v25 with SQL 2019 (supported to Jan. 2030) * RECOMMENDED
      
      
2. Users with Act! v24 or v25 that are fitted with SQL 2014
   1. Upgrade to SQL Express 2016. (supported until July 2026) - How to Upgrade SQL Server 2014 to SQL Server 2016
      
   2. Upgrade to SQL Express 2019 (supported until Jan. 2030)  * RECOMMENDED
      
      
3. Users with Act! v24 or v25 that are fitted with SQL 2019
   1. No action required

As all Act! upgrades are included free with the subscription, so there is no reason not to migrate to the latest supported versions of Act!, especially with a wide range of feature improvements and fixes included with each new release. Act! users may also choose to migrate to Act! Premium Cloud and access their data via a browser. The new Act! Premium Cloud offers a fast and secure service with automatic updates and no software to install.

SQL Compatibility Matrix

 
Helpful links related to SQL and Act! obsolescence issues:

 

Follow these steps to unlock

Keystroke always recommends that our customers only use supported versions of their business software, whether Act!, Windows, SQL, or Office, to ensure the safest, most secure, and productive user experience. Please email our This email address is being protected from spambots. You need JavaScript enabled to view it. or This email address is being protected from spambots. You need JavaScript enabled to view it. departments with any questions you have.