How to Resolve Sage 50 Firewall Errors and Network Connection Problems Quickly

Connectivity issues in Sage 50 often arise in multi-user environments where several users access company files simultaneously. Firewall restrictions can block communication between the server and workstations, leading to connection failures, slow performance, or errors when opening company files.

Such interruptions are common in multi-user setups and can disconnect systems from the server hosting company’s data. Quickly resolving firewall errors is essential to restore access, prevent disruptions in financial reporting, invoicing, and bookkeeping, and ensure smooth, uninterrupted accounting operations.

What Is a Sage 50 Firewall Error?

A Sage 50 Accounting software firewall error occurs when the firewall or security settings block communication between the workstation and the server. This prevents access to company data and can trigger a database Sage 50 connection problem, like Actian or Pervasive. Users may see messages like “cannot connect to data” when they open company files.

Resolve this issue by updating firewall settings, allowing Sage 50 executable files through the firewall, and opening the required TCP/IP ports. These actions restore system communication and ensure uninterrupted access to company files.

When Do Sage 50 Firewall Errors Occur?

Sage 50 firewall errors happen when security software blocks communication between workstations and the server, commonly in multi-user setups or on new/updated workstations. Users may see messages like “cannot connect to data” or face database connection failures, such as Actian or Pervasive errors.

System changes often trigger these issues. Windows updates, firewall setting changes, or Sage 50 updates can block required ports or applications. These blocks stop proper communication and prevent access to company files.

Common Causes of Sage 50 Firewall Errors

The following list identifies the main causes of firewall errors in Sage 50 that block system communication.

• Firewall Restrictions: Firewall or security software may block Sage 50 from accessing necessary ports and services.
• Database Service Blockage: Firewall or antivirus software can block database services such as Actian/Pervasive or connection managers, interrupting connectivity.
• Closed Network Ports: Closed or restricted ports can prevent communication between Sage 50 and the database server.
• Network Configuration Errors: Incorrect IP addresses, DNS settings, or server names can prevent multi-user communication.
• Software Upgrades: Installing or upgrading Sage 50 may trigger firewall alerts as the program attempts to reconnect.
• Incorrect Data Paths: Workstations with wrong data paths cannot access the server properly.
• Permission Issues: Lack of administrative rights or folder access permissions can block connection to company data.

How to Fix Sage 50 Firewall Errors and Network Connection Problems

Below are the step-by-step methods to fix firewall errors in Sage 50 Accounting software and restore access to company files.

Method 1: Move the Company File to Another Location

Move or restore your Sage 50 company file to a new folder or drive to fix access issues and confirm it opens correctly.

• Open the File menu in Sage 50 and select Open Company or Open Location.
• Restore or move your company file (SAJ or .SAI) to a new folder or drive.
• Avoid using temporary folders such as C:\Temp.
• Select the new location and open the company file.
• Check whether the file opens without errors.

A successful file opening confirms that the issue was related to the previous data path or network location.

Method 2: Update Windows Firewall Automatically

Uninstall and reinstall Sage 50, allowing the installer to update Windows Firewall automatically to restore proper access and connectivity.

• Uninstall the existing Sage 50 software from your system.
  • Open Control Panel.
  • Select Programs and Features.
  • Locate Sage 50 Accounting.
  • Right-click and choose Uninstall.
• Reinstall Sage 50 on your computer.
  • Navigate to C:\Sage\ on your system.
  • Open the folder for the latest version of Sage 50.
  • Start the installation process.
• During installation, allow automatic firewall configuration.
  • Click Yes when the system asks you to update Windows Firewall settings.
• Complete the installation and restart your system if required.

Method 3: Allow Sage 50 in Windows Firewall

Open Windows Firewall settings and allow all Sage 50 programs through the firewall for both Private and Public networks to ensure proper system connectivity.

• Open Windows Firewall settings and go to Allow an app through firewall.
• Ensure all required Sage 50 programs are listed and allowed for both Private and Public networks:
  • File and Printer Sharing
  • mysqld.exe
  • w3dbsmgr.exe
  • Sage 50 Accounting Connection Manager
• Verify that all related Sage 50 executable files are included in the allowed list.
• Click Allow another app to add any missing Sage 50 programs.
• Select the correct Sage 50 version currently installed on your system.
• Apply the changes and close the firewall settings.

Method 4: Open Inbound Firewall Ports

Open the required inbound TCP/IP ports in Windows Firewall on the server to allow Sage 50 to communicate with workstations and access company data.

• Perform these steps on the server (host computer) where the company data is stored.
• Open Windows Firewall with Advanced Security.
• Click on Inbound Rules and select New Rule.
• Choose Port and click Next.
• Select TCP and enter the required port numbers.
  • Example: 13531, 13540–13545 (range may vary).
• To confirm the correct port range:
  • Open File Explorer and navigate to:
  • C:\Users\Public\Documents\Sage Software\ConnectionManager\
  • Open ConnectionManager.ini in Notepad.
  • Locate the line End Port=xxxxxx to identify the port range.
• Click Next and select Allow the connection.
• Click Next and check Private and Domain profiles.
• Click Next, enter a name such as Sage 50 Accounting Ports, and click Finish.

Method 5: Open Outbound Firewall Ports

Open the required outbound TCP/IP ports in Windows Firewall on all network systems to ensure Sage 50 can send data to the server without interruptions.

• Configure these settings on all systems in the network, including the server and workstations.
• Open Windows Firewall with Advanced Security.
• Click on Outbound Rules and select New Rule.
• Choose Port and click Next.
• Select TCP and enter the same port numbers used for inbound rules (e.g., 13531, 13540–13545).
• Click Next and choose Allow the connection.
• Select Private and Domain profiles, then click Next.
• Enter a name such as Sage 50 Outbound Ports and click Finish.

Method 6: Restart the Computer

Restart the computer to refresh network services and resolve temporary connectivity issues in Sage 50.

• Restart the system to refresh network services.
• This helps resolve temporary glitches affecting connectivity.

Method 7: Run Sage 50 as Administrator

Run Sage 50 as an administrator to bypass permission restrictions and ensure proper access to company files.

• Right-click the Sage 50 icon and select Run as administrator.
• This bypasses permission-related restrictions.

Method 8: Disable Third-Party Firewall (Temporarily)

Temporarily disable third-party firewall or antivirus software to test connectivity, then re-enable it after confirming the issue is resolved.

• Turn off antivirus or firewall software for testing.
• Check whether the issue is resolved.
• Re-enable the firewall immediately after testing to maintain system security.

How to Configure Firewall for Sage 50 Setup

Configure Windows Firewall for Sage 50 by allowing the program through the firewall and adding it to the allowed apps list if it is not already included.

Windows 10 and 11

• Click the Windows search bar and type Firewall.
• Click Allow an app or feature through Windows Firewall on the left side.
• Find Sage 50 Accounting in the Allowed apps and features list. Select Allow another app when it is not listed.
• Select Sage 50 Accounting from the list and click Add.
• Add each of the following Sage 50 processes to the firewall exception list.
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\SageUpgrader.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\Sage_SA_Email.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\TST\Sage_SA_TST.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\Sage_SA_ODriveSync.exe
  • Program Files (x86)\winsim\ConnectionManager\SimplyConnectionManager.exe.
  • Program Files (x86)\winsim\ConnectionManager\Simply.SystemTrayIcon.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\dbverifier\Sage_SA_DBVerifier.exe
  • Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqladmin.exe
  • Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqldump.exe
  • Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqld.exe
• Then you have to click OK.

If you need to make changes to Windows Firewall Advanced Settings, refer to Windows Help for detailed information.

Windows Server 2025

Open the Start menu, select Settings, and then select Privacy & Security.

• Click Windows Security.
• Click Firewall & network protection.
• Click Allow an app through firewall.
• Check the Allowed apps and features list for Sage 50 Accounting. Click Allow another app when it is missing.
• In the Add an app dialogue box, find and select Sage 50 Accounting in the list.

Browse to locate Sage50Accounting.exe in the Sage 50 Accounting installation folder. Select the file, click Open, and then click Add. The default installation folder is C:\Program Files (x86)\Sage 50 [Your Product Solution] [Year].

• Repeat the steps above for each of the following processes:
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\Sage50Accounting.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\SageUpgrader.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\Sage_SA_Email.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\TST\Sage_SA_TST.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\Sage_SA_ODriveSync.exe
  • Program Files (x86)\winsim\ConnectionManager\SimplyConnectionManager.exe.
  • Program Files (x86)\winsim\ConnectionManager\Simply.SystemTrayIcon.exe
  • C:\Program Files (x86)\Sage 50 [Your Product Solution]\dbverifier\Sage_SA_DBVerifier.exe
  • Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqladmin.exe
  • Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqldump.exe
  • Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqld.exe
• Then click OK

If you need to make changes to Windows Firewall Advanced Settings, refer to Windows Help for detailed information.

Common Firewall-Related Errors in Sage 50

Firewall settings play a critical role in the smooth functioning of Sage 50, especially in multi-user environments. Incorrect or restrictive firewall configurations can block communication between the server and workstations, leading to various errors.

Below are the most common firewall-related errors in Sage 50, along with their causes:

1. Error: “Connection Manager Not Found”

This error appears when Sage 50 cannot connect to the database engine on the server.

Cause:

• Firewall blocking Sage 50 ports or services.
• Connection Manager service not allowed through the firewall.

2. Error: “Cannot Open Company File”

Users are unable to access the company file stored on the server.

Cause:

• Firewall blocking access to shared folders.
• Sage 50 executable files are not added to firewall exceptions.

3. Error: “Network Path Not Found”

The system cannot locate the shared network path when firewall settings block network discovery.

Cause:

• Firewall restrictions on network discovery.
• Blocked file and printer sharing settings.

4. Error: “Access Denied” in Multi-User Mode

Users cannot switch to or work in multi-user mode.

Cause:

• Firewall blocking communication between systems.
• Insufficient permissions combined with firewall restrictions.

5. Error: “Pervasive/Actian Database Engine Not Responding”

Sage 50 fails to communicate with the database engine.

Cause:

• Firewall blocking database engine ports
• Actian/Pervasive services not allowed through firewall

6. Error: “Sage 50 Cannot Connect to Its Database”

Firewall restrictions prevent users from opening or working on company data.

Cause:

• Firewall blocking inbound and outbound traffic for Sage 50
• Missing firewall rules for database communication

7. Error: “Timeout or Connection Lost”

Firewall restrictions stop active network communication, causing connection drops during Sage 50 operations.

Cause:

• Firewall interrupting continuous network communication
• Strict security rules terminating active sessions

Preventing Sage 50 Firewall Errors

Firewall issues in Sage 50 can interrupt workflows, block multi-user access, and cause frequent connection errors. A proactive setup helps avoid these problems and ensures smooth communication between systems.

• Regularly verify that Sage 50 is allowed through Windows Firewall
• Add Sage 50 executable files (like peachw.exe) to exceptions
• Enable both Private and Public network access
• Regularly review and update required ports for Sage 50 and its database engine
• Create inbound and outbound firewall rules
• Turn on Network Discovery on all systems
• Enable File and Printer Sharing
• Store company files in a shared, secure folder
• Avoid temporary locations like C:\Temp
• Set full folder permissions for all Sage users
• Ensure both sharing and security permissions are applied
• Keep firewall settings consistent on server and workstations
• Add Sage 50 exceptions in antivirus software
• Exclude Sage folders from real-time scanning
• Install latest updates for Sage 50 and Windows
• Test multi-user access regularly
• Confirm all systems can open the company file
• Monitor firewall logs for blocked connections
• Update rules whenever issues are detected

When to Contact Sage 50 Technical Support

Persistent firewall errors after basic troubleshooting steps, such as configuring firewall exceptions, opening required ports, and verifying network settings, require expert support. Support is also recommended when users face repeated database connection failures, multi-user access issues, or error messages that are difficult to identify. Situations involving corrupted company files, complex server configuration problems, or permission-related restrictions may require expert assistance to prevent data loss and ensure smooth operation. Reaching out to Sage 50 technical support helps resolve issues quickly and minimises disruption to accounting activities.

Conclusion

Sage 50 firewall errors can block access, disrupt multi-user operations, and slow down performance. Following the step-by-step solutions, including moving or restoring company files, updating Windows Firewall, allowing Sage 50 programs through the firewall, opening inbound and outbound ports, running Sage 50 as an administrator, and verifying network and permission settings, resolves most firewall issues efficiently. Regularly reviewing firewall rules, maintaining up-to-date software, and enforcing consistent network configurations ensures reliable, secure access to company files and support uninterrupted multi-user operations.

For immediate assistance, our experts are available 24/7 to resolve Sage 50 firewall and connectivity problems quickly, keeping your business running without interruptions.

Frequently Asked Questions