How do I manually install Actian PSQL version 12 Engine?

Steps to manually install Actian PSQL version 12 for Sage 300 CRE for server or workstation.

 CAUTION: This solution requires advanced knowledge of Windows security and network settings. Sage isn't responsible for any issues that arise from changes to these settings. Ensure you back up all system and application databases necessary for a complete restoration. It's advisable to contact a certified consultant or your system administrator for assistance.

 

Overview

These steps apply for versions 24.1 and earlier. For versions 24.2 and later, see steps to install the Actian Zen 15 engine.

Install Actian through the Install.exe option. When you install through Install.exe, Actian will lay down all the required components.

Previously, Estimating file servers functioned with only Actian installed. Due to Actian activation requirements in versions 13.1 and later, you must install Sage Estimating or Sage 300 CRE on any Estimating file server.

Uninstall Actian and then install either the client or the server engine.

 

Uninstall Actian

Uninstall Actian Client or Actian Server Engine in Programs and Features.

Install Actian Client Engine

1. Browse to \\Server\Timberline Office\9.5\Accounting\Wininst\Prerequisites\.
2. Run Pre PSQL Install\PrePSQLInstall.exe. This install runs silently, but you can monitor it in Task Manager.
3. Run Pervasive PSQL v12 Client Edition (x86)\SetupClient32_x86.exe.
4. Run Pervasive PSQL v12 Client Patch (x86)\PSQLv12Patch_Client32_x86.msp.
5. Run Post PSQL Install\PostPSQLInstall.exe. This install runs silently, but you can monitor it in Task Manager.

Install Actian Server Engine

1. Browse to \\Server\Timberline Office\9.5\Accounting\Wininst\Prerequisites\.
2. Run Pre PSQL Install\PrePSQLInstall.exe. This install runs silently, but you can monitor it in Task Manager.
3. Run Pervasive PSQL v12 SP1 Server Edition (x64)\SetupServer64_x64.exe.
4. Run Pervasive PSQL v12 Server Patch SP1 (x64)\PSQLv12Patch_Server64_x64.msp.
5. Run Post PSQL64 Install\PostPSQL64Install.exe. This install runs silently, but you can monitor it in Task Manager.
6. Optional, perform if needed:
   1. Browse to \\Server\Timberline Office\9.5\Accounting\Wininst\Prerequisites\Pervasive License Monitoring Service.
   2. Run PSQLLMInst. This install runs silently, but you can monitor it in Task Manager.
   3. Go to services.msc.
   4. Select Sage Pervasive License Service L2 and click Start.
7. Go to Windows Start button, All Programs, Sage Administration.
8. Right-click Sage System Verifier and select Run as administrator.
9. Click Scan system and confirm the scan completes.
10. Log in to Sage.