Sage 50 Firewall Error : Configure Firewall Run Sage

Fix Sage Software Windows Firewall Blocking Issue

How to Fix Firewall Problem During Install, Update Sage 50

Contents

1 How to Fix Firewall Problem During Install, Update Sage 50
2 Why do Firewall Ports Block Sage Accounting Software?
3 Firewall requirements for Sage 50 Accounts
- 3.1 Check which firewall you’re using
- 3.2 Ports to exclude from firewall
4 How to Fix Sage Firewall Problems?
- 4.1 Method 1: Shift the company file to another location
- 4.2 Method 2: Update Windows Firewall automatically
5 Sage 50 Firewall Ports To Allow on Windows OS
6 Set Up the Windows Firewall for Sage 50 Accounting
- 6.1 Help For Troubleshooting Windows Firewall Issue With Sage 50
7 Sage 50cloud Pastel (ZA) – How do I add the Pervasive ports to the Windows firewall?
8 Sage 100 – How to configure Windows Firewall for Sage 100 Advanced and Premium
9 Frequently Asked Questions(Faqs)

Issue Name: SAGE 50 Firewall Block
Applicable for Product: Sage Line 50, SAGE, Sage 50 Canada, Sage 50 Accounts, Sage 50, SAGE ACT, Sage Taxation, SAGE 100, SAGE 300, Peachtree, Sage 50 Premium, Sage Contractor 100
Description: Due to firewall settings, users are either unable to Install Sage accounting software or facing issues while opening company files, connecting databases, or even running reports.
Errors Messages: Windows Firewall Detected Sage. Exe as suspicious script want to gain access to the system, hence blocked
Error: “Cannot open company, there is an error connecting to a database” when trying to open a data file.
Sage 50 detected a firewall that may be blocking files also required by Sage 50
A network error occurred while communicating with the Connection Manager. Please wait a moment and try again
Reports: Not Applicable

With Sage 50 accounting software, users have come across various effective tools and features that enable people to perform all accounting and payroll functions hassle-freely.

However, there are scenarios when the software operation gets interrupted because of certain technical errors. You might have heard many times that a software error arises when the firewall blocks it from performing. Sage 50 firewall error is the most common technical issue that you may come across.

The AccountsPro team comprises many expert individuals who acquire skills in handling Sage 50 errors. You can contact them anytime whenever you feel like getting assisted with software-related issues.

Why do Firewall Ports Block Sage Accounting Software?

When it is to firewall issues, the causes can be one of the following:

The update file for the software is unrecognized by the Windows Firewall installed in your system
New MySQL Connector ODBC version has been installed
The update did not get installed on the Server

The error is encountered when you try to open your company file locally. The error message may show the error accompanied by the message stating “Sage 50 detected a firewall which may be blocking files also required by Sage 50…”

Firewall requirements for Sage 50 Accounts

A Sage 50 Accounts Data Service is installed on the computer or server that holds Sage 50 Accounts data. It acts as a gateway and controls data reading and writing.

You may need to contact your IT administrator for further assistance.

Sage 50 Accounts does not interfere with firewalls, as explained in this guide.

Check which firewall you’re using

Using the following options, you can find out which antivirus or firewall software you use:

Open Help > About and check the Firewall details under System Details if you’re using Sage 50cloud Accounts.
In the list of all programs, look for an anti-virus or firewall program.
Navigate to Start > Settings > Control Panel > check for any antivirus or firewall software.
Start > Run > enter services.msc > OK > look for anti-virus/firewall software in the Services list.
You can find the system tray in the bottom right corner of your screen next to the clock. Hovering over each option shows you the name of the application that is running. Look for any virus or firewall software.

Ports to exclude from firewall

Make sure the following ports are open on your firewall so Sage Data Service won’t be blocked

Sage Accounts v28	1. Sage 50 Accounts Control v28: TCP 34228 2. Sage 50 Accounts Service v28: TCP 32228 & 32328
Sage Accounts v27	1. Sage 50 Accounts Control v27: TCP 34227 2. Sage 50 Accounts Service v27: TCP 32227
Sage Accounts v26	1. Sage 50 Accounts Control v26: TCP 34226 2. Sage 50 Accounts Service v26: TCP 32226
Sage Accounts v25	1. Sage 50 Accounts Control v25: TCP 34225 2. Sage 50 Accounts Service v25: TCP 32225
Sage Accounts v24	1. Sage 50 Accounts Control v24: TCP 34224 2. Sage 50 Accounts Service v24: TCP 32224

For each port, you can specify an IP address. If you use dynamic IP addresses, you cannot use this. On the server, you can add the IP addresses of the client computers to the inbound rule for the port. On the client computers, you can add the IP address of the server to the outbound rule for the port.

How to Fix Sage Firewall Problems?

If you are experiencing problems with your Sage 50 firewall, there are a few things that you can do to fix the problem. First, make sure that you have the latest updates for your firewall software. Next, try restarting your computer and your firewall. If these solutions fail, you may need to follow the below-given methods to help you troubleshoot the issue.

Method 1: Shift the company file to another location

If you are having trouble opening or editing a company file, you can shift it to another location on your computer. To do this, open the File menu and select Open Location. In the Open Location dialog box, select the directory where you want to save the file, and then click OK.

Restore your company (SAJ or .SAI) file to some other location
Don’t opt for a temporary folder i.e. C:\Temp
Try and open the company file
If it opens, your problem is resolved

Method 2: Update Windows Firewall automatically

Windows Firewall is a security feature that protects your computer from unauthorized access. You can update Windows Firewall automatically using the Windows Update service. This will keep your computer protection up to date.

Uninstall the Sage 50 software
- Go to Control Panel
- Select Programs & Features
- Search Sage 50 Accounting option
- Right-click it
- Click Uninstall
Install the software
- Browse to C:\Sage\
- Open the latest version of the software
While installing the software, you will be asked to automatically update your firewall Click Yes

Sage 50 Firewall Ports To Allow on Windows OS

Users need to allow the following Ports in Firewall settings to work with Sage 50 Accounting software
Ports 3531, 13540-13545
Connection Manager: port 13531
MySQL: ports from 13540 to 13579
13531, 13540 – 13542
Process or Exe to Allow Sage 50 Canadian Edition Alchemex.NET.Installation.Advertise.exe
BlCore.exe
Sage50Accounting.exe
Sage_SA_upload.exe
Sage_SA_Policy.exe
simplyurl.exe
Sage_SA_webhelp.exe
mysqld-nt.exe
mysqladmin.exe
SimplyConnectionManager.exe
Simply.SystemTrayIcon.exe
Sage_SA.TransactionManager.exe
AlchemexPolicy.exe
Sage_SA_conv160.exe
Sage_SA_conv150.exe
Sage_SA_conv170.exe
Sage_SA_ErrorLogSubmitter.exe
Sage_SA_DBVerifier.exe

In case, you think you have a problem with following the steps, you can connect with our Sage 50 support team. The technical team of experts there will enable you to handle the issues well.

Set Up the Windows Firewall for Sage 50 Accounting

To configure your firewall to work with Sage 50 Accounting:

Windows 8.1

Open the Start menu, select Control Panel, System and Security, Windows Firewall, and then Allow a program or feature through Windows Firewall.
If Sage 50 Accounting is not in the Allowed Programs and Features list, click Change Settings.
Click Allow Another Program, and select Sage 50 Accounting from the list, and click Add.

If Sage 50 Accounting does not appear in the Add a Program list, click Browse to locate Sage50Accounting.exe in your Sage 50 Accounting installation folder, click Open, and then OK. 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
- C:\Program Files (x86)\Sage 50 [Your Product Solution]\Intelligence Reporting\Alchemex.NET.Installation.Advertise.exe (Required for Sage 50 Intelligence Reporting)
- C:\Program Files (x86)\Sage 50 [Your Product Solution]\Intelligence Reporting\PO\AlchemexPolicy.exe (Required for Sage 50 Intelligence Reporting)
- 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\5.6.10\mysql\mysqladmin.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10\mysql\mysqldump.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10\mysql\mysqld.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysqladmin.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysqldump.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysqld.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.27\mysql\mysqladmin.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.27\mysql\mysqldump.exe
- Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.27\mysql\mysqld.exe
Click OK.