To configure your Sage 300 CRE Client on a dedicated Remote Desktop Server, there are a couple of things to know. The default workstation (or client) installation performed on a Remote Desktop (RD) Server will configure the system with a less than optimal configuration to support this environment. The default client installation is fine for a typical Windows 10 workstations and notebooks. On an RD Server, it will initially run and work, but commonly two issues come to light over time:
When you install Sage 300 CRE Client, the installer will install the Pervasive / Actian PSQL 32 bit Client. Typically, the client installation is run from the path:
In these cases with a dedicated RD Server, it is recommended remove the 32 bit PSQL Client and install the 64 bit PSQL Server Edition.
Update the RD Server to use PSQL x64 Server Edition
Next disable the PSQL Cache on the RD Server. Use the PSQL Control Center to disable the Cache.
Click Configure Microkernel Router
From the File menu, select Exit PCC
These two changes on an RD Server (or Citrix Sever) have shown to improve the usability and stability of the Sage 300 CRE client.
Sage KB 83047 How do I manually install Actian PSQL version 12?
Sage KB 54524 How do i turn off the PSQL Cache?
Rod Hatley, Practice Manager, leads the Aktion service team in delivering IT infrastructure and cloud solutions. Rod has more than 25 years of experience in IT.