The cart is empty
Category: Act! Tips
Written by Ken Quigley
May 27 2024

Recent survey results suggest that a majority of Act! users who upgraded to Act! v24 or v25 from a 32-bit version may still be using the soon-to-be-deprecated SQL 2014. If you're not familiar with the risks of using unsupported versions of SQL, please read this blog. To reduce the security risk for this cohort, we encourage them to upgrade to the safer SQL Server 2019 by following a series of simple steps to ensure a smooth transition.

Here’s a high-level overview of this SQL upgrade process:

  1. Verify Your Current Versions: Check your current SQL and Act! versions to confirm the need for an upgrade
    • Holding down the Windows key + R, typing in "actdiag" in the dialogue box, and clicking OK will show you the SQL version you're using with Act!
  2. Backup Your Act! Database: It’s critical to back up your Act! databases before proceeding with the upgrade.
    • This practical advice all database upgrades
  3. Uninstall Act!: Remove the current version of Act! from your system from the Control Panel, and then Uninstall SQL Server 2014 ACT7 Instance
    • This step is necessary to prepare for the new SQL Server 2019 installation.
  4. Restart your computer: Act! will always check if a restart is pending, so it is best to do this before attempting to reinstall Act!.
  5. Install Act! v25: The final step is to reinstall Act! v25, which will include the new SQL Server 2019.

Please note that Act! Pro v24 users cannot upgrade to v25 since Act! Pro was discontinued with the v24 version.
Also, unlike previous versions of Act!, the v24 version of Pro is feature-gated, so it uses the same installer as the Premium software. 

You can perform an "in-place upgrade" of SQL 2014 to 2019 using the download file HERE, following the similar upgrade instructions for upgrading 2014 to 2016 spelled out in this blog. Given the simplicity and reliability of the five steps listed above, Keystroke recommends this approach over in-place upgrades.

Remember, it’s important to ensure that your system meets the requirements of SQL Server 2019 before starting the upgrade process. If you encounter any issues or have specific questions during the upgrade, Keystroke will respond to emailed inquiries sent to This email address is being protected from spambots. You need JavaScript enabled to view it.. Good luck with your upgrade!

Share with a friend

Who we are?

Specializing in CRM software for small to medium sized businesses, through expert counsel, deployment, hosting, support, and development services.

Delivering fruitful CRM solutions since 1994, Keystroke is the #1 Act! Reseller in the World and Master Act! Distributor for Canada.

Contact Keystroke

Get in Touch

Toronto   500 Gordon Baker Rd. Toronto, ON, M2H 3B4
Toll Free : 800.857.0558
Office : 416.499.3090
Fax : 416.499.1090

Kitchener   250 Woolwich St. S. Breslau, ON N0B 1M0
Toll Free : 800.939.4737 Ext. 1
Office : 519.579.1408


Pay your bill online


Monday to Friday: 9AM to 6PM EST
Saturday & Sunday: Closed

Your Cart

Customers that ordered this item frequently bundle it with the following products or services for the best user experience
Save 10% on eligible items when bundled with this product
The cart is empty
Continue shopping