1. Home
  2. Transact
  3. Install and Upgrade
  4. Additional Resources
  5. Windows
  6. Prerequisites for Configuring Transact with Microsoft SQL Server

Prerequisites for Configuring Transact with Microsoft SQL Server

See Platform Configurations and Third-Party Integrations to determine which operating system, database, and third-party integrations are supported for your version of Ephesoft Transact.

If using an existing database, make sure you have SQL Server client installed. For that, download and install the following software in the mentioned order on the Transact Server before installing Transact:

  1. Microsoft® SQL Server® 2012 Native Client – QFE (Version 11.4.7001.0)
  2. Microsoft® ODBC Driver 17 for SQL Server® (Version 17.8.1)
  3. Microsoft® Command Line Utilities 15 for SQL Server® (Ephesoft Transact 2022.1.00 only)

Note: Please visit the Ephesoft Customer Support to download the supported version of Ephesoft Transact 2020.1.06 MSSQL Components.

Workaround for Transact

There is a compatibility issue with SQL Server 2008R2 (shipped as a part of Ephesoft Transact installer) on Windows Server 2012R2, Windows 8 or higher versions. However, there is a workaround provided by Microsoft to make Windows Server 2012R2 (and Windows 8) compatible with SQL Server 2008R2. This can be done by installing an additional Service Pack. You can find all required information in the following Microsoft article:

Using SQL Server in Windows 8 and later versions of Windows operating system

Note: Microsoft SQL Server 2008R2 is not compatible with Windows 10 or Windows Server 2016.

Was this article helpful to you? Yes No 2