How to Fix Sage Pastel Error Code 20

Sage Pastel Error Code 20 is a common issue that usually appears when the software cannot connect properly with the Pervasive database engine. This error can occur due to incorrect licensing, disabled services, firewall restrictions, damaged Pervasive files, or network-related problems. When the error appears, users may face issues while opening Sage 50cloud Pastel or accessing company data. In this complete guide, we will explain the common causes of Sage Pastel Error 20, important things to check before troubleshooting, and verified methods to fix the issue step by step.

What Is Sage Pastel Error Code 20?

Sage Pastel Error Code 20 is a common database-related error that usually occurs when Sage 50cloud Pastel is unable to communicate properly with the Pervasive database engine. This issue can appear due to incorrect Pervasive installation, licensing problems, disabled services, firewall restrictions, or network configuration issues. When this error occurs, users may face difficulty opening the software, accessing company files, or connecting workstations to the server.

Common Causes of Sage Pastel Error Code 20

Here are some of the most common reasons behind this error:

• An incorrect or unsupported Pervasive version is installed.
• Pervasive engine or service not running.
• Missing or invalid Pervasive license.
• Disabled .NET Framework.
• Windows Firewall is blocking Pervasive services or ports.
• Corrupted or damaged Pervasive files.
• Incorrect workstation mapped drive path.
• UTF-8 worldwide language support is enabled in Windows.
• Network or server connection issues.
• Improper Pervasive installation or configuration.

Things to Check Before Troubleshooting

• Verify the installed Pervasive version and license.
• Make sure the Pervasive engine is running.
• Check that the .NET Framework is enabled.
• Ensure Windows Firewall is not blocking Pervasive services.
• Confirm the workstation path points to the correct mapped drive.
• Disable the UTF-8 worldwide language support option in Windows.
• Check server and network connectivity.
• Restart the system before troubleshooting further.

Verified Solutions to Fix Sage Pastel Error Code 20

If you are facing Error Code 20 in Sage Pastel, the following verified solutions can help you identify the root cause and resolve the issue step by step. Follow each method carefully to restore proper communication between Sage 50cloud Pastel and the Pervasive database engine.

Method 01: Check the Installed Pervasive Version

Using the correct Pervasive version is important for Sage 50cloud Pastel to work properly. If the installed version does not match the licensed version, you may face Error Code 20. Follow these steps to check the installed Pervasive version:

• Type Control Panel in the Windows search bar and open it.
• Change the View by option to Large icons or Small icons.
• Click Programs and Features.
• Look for the installed database version, such as Pervasive PSQL v9, v10, or Actian for version 13.
• Now open Sage 50cloud Pastel.
• Click Help and then select About.
• Check whether the displayed Pervasive Engine version matches the version installed on your computer.

If both versions are different, uninstall the incorrect version and install the one that matches your Sage 50cloud Pastel license.

Method 02: Restart the Pervasive Engine

Sometimes Sage 50cloud Pastel Error Code 20 happens when the Pervasive database service stops working properly. Restarting the engine can fix the connection and help the software run normally again.

• Type Engine in the Windows search bar.
• Select Stop Workgroup Engine.
• Again, type Engine in the search bar.
• Click Start Workgroup Engine to restart the service.

If you cannot find these options, follow the alternate steps below:

• Type Control Panel in the Windows search and open it.
• Click Administrative Tools.
• Select Services.
• Locate Pervasive PSQL Engine or Actian for Version 13.
• Click Start or Restart Service from the left-hand panel.

Once the service restarts, open Sage 50cloud Pastel again and check whether the error has been resolved.

Method 03: Disable User Account Control (UAC)

Windows User Account Control (UAC) can sometimes prevent Sage 50cloud Pastel from applying licenses correctly. Disabling this setting may help fix Error Code 20. Follow these steps to turn off UAC:

• Type UAC in the Windows search bar.
• Select Change User Account Control settings.
• Move the slider down to Never notify.
• Click OK to save the changes.
• If prompted, confirm your selection or enter the administrator password.
• Restart your computer.

After restarting the system, refresh the Sage 50cloud Pastel registration so the licenses can apply correctly.

Method 04: Verify Pervasive Licensing

Incorrect or missing Pervasive licensing can cause Sage 50cloud Pastel Error Code 20. Checking the license details helps make sure the database engine is activated properly.

• Press the Windows + E keys together to open File Explorer.
• Search for GUICLADM.EXE  and open it.
• Check whether the Permanent Licenses information is showing correctly.
• For Version 9 and Version 13, you should normally see one line showing the license type as Permanent, along with the number of licensed users.
• For Version 10, you may see two entries: Permanent and User Count Increase.
• If you are using Pervasive Client/Server, enter the provided license key on the server and click Authorize.
• If you are using Pervasive Workgroup, uninstall and reinstall Pervasive to refresh the licensing setup.

Method 05: Enable .NET Framework

The .NET Framework is required for Sage 50cloud Pastel and several Windows features to work properly. If it is disabled, you may experience Error Code 20 or other system issues. Follow these steps to enable the .NET Framework:

• Type Turn Windows features on or off in the Windows search bar and open it.
• Locate the .NET Framework 3.5 and .NET Framework 4.7 options.
• Make sure all the boxes under both versions are selected.
• Click OK to save the changes.
• Wait for Windows to install and enable the required features.

Method 06: Configure Windows Firewall

Windows Firewall can sometimes block communication between Sage 50cloud Pastel, the server, and workstations. Adding the Pervasive database service and ports to the firewall exceptions can help fix Error Code 20.

Add the Pervasive Database to the Firewall

• Open Control Panel from the Windows search bar.
• Set View by to Large icons or Small icons.
• Select Windows Firewall and then click Advanced Settings.
• Choose Inbound Rules and click New Rule.
• Select Program and choose This program path.
• Browse to: C:\Program Files (x86)\Pervasive Software\PSQL\bin
• Select w3dbsmgr.exe and click Open.
• Click Next, choose Allow the connection, and continue.
• Enter a name such as Pervasive Database and click Finish.
• Repeat the same steps under Outbound Rules.

Add the Pervasive Ports to the Firewall

• In Windows Firewall Advanced Settings, select Inbound Rules and click New Rule.
• Choose Port and click Next.
• Select Specific local ports and enter: 3351, 1583
• Click Next and select Allow the connection.
• Continue through the setup and give the rule a name such as Pervasive Ports.
• Click Finish and repeat the same steps under Outbound Rules.

Method 07: Reinstall Pervasive to Fix Sage Pastel Error Code 20

Corrupted or missing Pervasive files can trigger Sage 50cloud Pastel Error Code 20. Uninstalling and reinstalling Pervasive can help replace damaged files and restore proper functionality.

First, Uninstall Pervasive

• Open the Start menu and go to Control Panel.
• Click Programs and Features.
• Locate Pervasive PSQL v10 or Actian PSQL v13.
• Right-click the program and select Uninstall.
• Once the process is complete, close the Control Panel.

Then, Reinstall Pervasive Again

• Visit the official Sage Pastel update portal.
• Open the Pervasive PSQL section and download the required version.
• Go to the downloaded ZIP folder, right-click it, and select Extract All.
• Open the extracted folder.
• Depending on your setup, locate setupworkgroup, setupserver, or setupclient.
• Double-click the setup file to begin the installation.
• Click Next and accept the license agreement.
• Select Install as a Service and continue with the installation steps.
• Click Finish after the installation is completed.

Method 08: Correct the “Start In” Path on Workstations

If you are using Pervasive Client/Server, an incorrect “Start In” path on the workstation can cause Sage 50cloud Pastel Error Code 20. Make sure the shortcut points to the correct mapped drive.

1. On the workstation, right-click the Pastel desktop icon.
2. Select Properties and open the Shortcut tab.
3. In the Start In field, enter the correct mapped drive location.
4. Make sure the path points to the shared network drive used for Sage 50cloud Pastel.
5. Click Apply and then OK to save the changes.

Method 09: Disable UTF-8 Worldwide Language Support

The Windows setting “Beta: Use Unicode UTF-8 for worldwide language support” can sometimes interfere with Sage 50cloud Pastel and cause Error Code 20. Disabling this option may help resolve the issue.

• Open Control Panel from the Windows search bar.
• Set View by to Large icons or Small icons.
• Click Region.
• Open the Administrative tab.
• Select Change system locale.
• Uncheck the option Beta: Use Unicode UTF-8 for worldwide language support.
• Click OK to save the changes.

Restart your computer after making the changes, and then open Sage 50cloud Pastel again.

How to Prevent Sage Pastel Error Code 20

• Use the correct and licensed Pervasive version.
• Keep the Pervasive engine running properly.
• Verify Pervasive licensing details regularly.
• Enable the required .NET Framework versions in Windows.
• Configure Windows Firewall settings correctly.
• Make sure workstation “Start In” paths point to the correct mapped drive.
• Avoid enabling the UTF-8 worldwide language support option in Windows.
• Keep Pervasive files updated and free from corruption.
• Restart the server and services regularly to maintain proper connectivity.
• Check network and server connections to avoid communication issues.

When to Contact Sage Pastel Support

If Sage Pastel Error Code 20 still appears after trying all the methods, you should contact Sage Pastel support. Some issues may be related to licensing, server settings, network problems, or damaged files that require expert assistance. If you are still unable to fix the error, you can connect with us, and our support team will help you resolve the issue quickly.

Frequently Asked Questions (FAQs)