Fix Sage Pastel Error Code 20: Step-by-Step Guide

Updated On: April 2, 2026 10:57 am

Sage Pastel error code 20 is a database connectivity issue that indicates your Pervasive or Actian Database Engine stopped running, lacks a valid license, or suffered an improper installation. This error prevents Sage Pastel from connecting to your company data, resulting in a Sage Pastel login issue.

Sage Pastel needs the database engine to run. If it stops, you cannot access your data. You must ensure the Pervasive Workgroup Engine is active in the system tray and verified as licensed to restore full functionality. Furthermore, your network security settings must permit traffic through specific database ports to maintain a stable connection.

This guide helps you identify the causes of this error and provides technical steps to restore your access.

Quick Actions to Take Immediately

• Stop your login attempts once the error appears to prevent further system stress.
• Restart your workstation to trigger an automatic refresh of the database services.
• Check the system tray for the Pervasive icon to see if the engine is active.
• Ensure all other users log out if you are performing repairs on a shared server.

Common Causes of Sage Pastel Error Code 20

Identifying the specific cause helps you choose the correct repair path. Most instances of this error result from environmental changes or service interruptions.

• Service Inactivity: The Pervasive Workgroup Engine service is not currently running on your workstation or server.
• Licensing Issues: The database license expired or failed to validate, forcing the engine into an inactive state.
• Network Port Blockage: Windows Defender Firewall or third-party security software blocks TCP ports 1583 and 3351.
• System Region Settings: The “Beta: Use Unicode UTF-8” setting in Windows creates a direct conflict with the database engine.
• Incorrect File Paths: The “Start In” path in your Pastel shortcut properties points to a local drive instead of the required mapped network drive.
• User Account Control (UAC) Restrictions: High UAC settings prevent the database engine from launching with the necessary permissions.

Symptoms of Sage Pastel Error Code 20

You will notice several clear indicators when this database failure occurs. Recognizing these signs early prevents repeated failed login attempts.

• Immediate Error Message: A pop-up stating “Error Code 20” appears as soon as you double-click the Sage Pastel icon.
• Login Failure: The software fails to reach the login credentials screen, resulting in a persistent Sage Pastel access error.
• Service Tray Absence: The Pervasive icon (a small engine with a red or green light) is missing from your Windows taskbar.
• Connection Timeouts: In client-server environments, your workstation takes an unusually long time to respond before displaying the error.

Quick Checks Before Troubleshooting

Before applying technical fixes, perform these preliminary checks to save time.

1. Reboot your system: A restart often initializes the Pervasive service automatically.
2. Verify the system tray: Expand your system tray icons to see if the Pervasive Workgroup Engine is visible.
3. Check network access: Ensure your mapped network drives are active and accessible via Windows File Explorer.

Also Read: Fix Sage 50 cannot be started error

Step By Step Guide to Fix Sage Pastel Error Code 20

Applying these steps in order restores the communication link between your accounting software and the database.

Step 1: Restart the Pervasive Engine

The engine must be active for the software to function.

• Locate the Pervasive icon in your Windows taskbar.
• Right-click the icon and select Start Workgroup Engine or Start Service.

This action manually initializes the database manager, allowing Sage Pastel to detect the active connection.

Step 2: Verify Database Licensing

An invalid license prevents the engine from responding to data requests.

• Open the Windows Start menu and search for PSQL License Administrator.
• Check the status of the license; it should show as Permanent and Active.
  

If no license is present, re-enter your valid registration key to re-activate the engine functionality.

Step 3: Configure Firewall Settings

Firewalls often block the ports required for database traffic.

• Open Windows Defender Firewall and navigate to Advanced Settings.
• Create New Inbound and Outbound Rules for TCP Ports 1583 and 3351.

This opens the communication channels so that the firewall does not stop the database from sending information to the application.

Step 4: Disable Beta UTF-8 Support

This specific Windows setting is known to cause compatibility failures with the Pervasive engine.

• Navigate to Control Panel > Region > Administrative.
• Click Change System Locale.
• Uncheck the box for Beta: Use Unicode UTF-8 for worldwide language support and restart your computer.

Disabling this feature restores the standard character encoding that the database engine requires to run.

Step 5: Correct the “Start In” Shortcut Path

On workstations, your shortcut must point to the shared data location on the server.

• Right-click your Sage Pastel icon and select Properties.
• Under the Shortcut tab, examine the Start in field.
• Ensure the path points to the mapped network drive (e.g., P:\PastelXX) rather than a local C:\ drive path.

Updating this path ensures the software looks for the database engine and data files in the correct network location.

Step 6: Adjust User Account Control (UAC)

High security settings often block the database service from starting correctly.

• Search for UAC in the Start menu and select Change User Account Control settings.
• Move the slider down to Never Notify and click OK.

Note: Always restore your UAC settings to their original level once you finish testing to maintain system security.

Also Read: Fix Sage 50 cannot open company file error

Best Practices to Prevent Sage Pastel Error Code 20

Maintaining your system environment prevents the recurrence of connectivity failures.

• Static IP Addresses: Assign static IPs to your server to ensure mapped drives maintain a constant connection.
• Wired Connections: Use a wired Ethernet connection for all Sage Pastel workstations, as signal drops lead to database engine failures.
• Scheduled Backups: Run daily backups to protect your data in case of a severe database service crash.
• Antivirus Exclusions: Add the Pervasive and Sage Pastel folders to your antivirus exclusion list to prevent file locking.

When to Contact Sage Support

While these steps fix most connectivity issues, some situations require professional intervention. Contact support if:

• The Pervasive service fails to start even after you reinstall the Actian engine.
• You receive a “License Expired” message for a product that requires a permanent license.
• The error persists only on the server, suggesting deeper corruption of the database installation.

Also Read: Fix Sage 50 data corruption error

Final Words

Resolving Sage Pastel error code 20 involves verifying the status and configuration of the Pervasive database engine. By ensuring the service runs, ports remain open, and regional settings are compatible, you quickly clear this login issue. Most database errors result from simple environmental changes that you can correct using built-in Windows and Pervasive utilities. Consistent system maintenance and following the recommended network settings help you avoid these technical failures and keep your accounting software running smoothly.

Frequently Asked Questions: