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-free.
Sage 50 firewall errors usually happen when your computer’s security settings block the software. To fix this, you’ll need to ensure your firewall and antivirus programs aren’t preventing Sage 50 from running properly.
That means allowing Sage 50’s necessary processes and network ports through your firewall. Once you adjust these settings, Sage 50 can connect smoothly with your network or the internet.
The AccountsPro team comprises many experts who have acquired skills in handling Sage 50 errors. You can contact them anytime whenever you feel like getting assistance with software-related issues.
| Issue Name | Sage 50 Firewall Block |
| Errors Messages | Windows Firewall detected Sage.exe as a suspicious script that wants to gain access to the system, hence blocked OR Error: “Cannot open company, there is an error connecting to a database” when trying to open a data file. OR 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 |
| Applicable for Product | Sage 50, Sage 50 Canada, Sage 50 Accounts, Sage ACT, Sage Taxation, Sage 100, Sage 300, Peachtree, Sage 50 Premium, Sage Contractor 100 |
| Reports | Not Applicable |
Table of Contents
- 1 Why do Firewall Ports Block Sage 50 Accounting Software?
- 2 What are the Methods to fix the Sage 50 firewall Error?
- 3 Steps to Set Up the Windows Firewall for Sage 50 Accounting
- 4 What are the Firewall Requirements for Sage 50 Accounts?
- 5 Sage 50 Firewall Ports To Allow on Windows OS
- 6 Frequently Asked Questions
Why do Firewall Ports Block Sage 50 Accounting Software?
When it comes to firewall issues, the causes can be one of the following:
- The update file for the software is unrecognized by the Windows Firewall installed on your system
- A 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…”
What are the Methods to fix the Sage 50 firewall Error?
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 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 move 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 another 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 the Control Panel
- Select Programs & Features
- Search the 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
Steps to Set Up the Windows Firewall for Sage 50 Accounting
To configure your firewall to work with Sage 50 Accounting during the update:
Windows 10 and 11
- Open the Windows search bar and type firewall.
- Click on the Allow an app or feature through Windows Firewall option on the left side.
- In case Sage 50 Accounting is not in the list of allowed apps, click on the Allow another app option.
- In the Add an App dialog box, locate and select the Sage 50 Accounting executable file (usually located at C:\Program Files (x86)\Sage 50 Accounting\Sage50Accounting.exe).
- Click on the Add button.
Note: 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 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
- Click OK.
If you need to make changes to Windows Firewall Advanced Settings, refer to Windows’ help for detailed information.
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, 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.
If you need to make changes to Windows Firewall Advanced Settings, refer to Windows’ help for detailed information.
Windows Server 2012 and Windows Server 2012 R2
- Open the Start menu, select Control Panel, and then select System and Security.
- Click Allow an app through Windows Firewall.
- If Sage 50 Accounting is not in the list under Allowed Apps and Features, then click Allow another app.
- In the Add an app dialog box, find and select Sage 50 Accounting in the list.
You can also click Browse to locate Sage50Accounting.exe in your Sage 50 Accounting installation folder. Click Open and then 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
- Click OK.
If you need to make changes to Windows Firewall Advanced Settings, refer to Windows’ help for detailed information.
Windows Server 2016
- Open the Start menu, select Settings, and then select Network & Internet.
- Click Windows Firewall.
- Click Allow an app through Windows Firewall.
- If Sage 50 Accounting is not in the list under Allowed Apps and Features, then click Allow another app.
- In the Add an app dialog box, find and select Sage 50 Accounting in the list.
You can also click Browse to locate Sage50Accounting.exe in your Sage 50 Accounting installation folder. Click Open and then 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
- Click OK.
If you need to make changes to Windows Firewall Advanced Settings, refer to Windows’ help for detailed information.
Windows Server 2019
- Open the Start menu > select Settings > and select Update & Security.
- Then, click Windows Security.
- Click Firewall & Network Protection.
- Click Allow an app through Windows Firewall.
- If Sage 50 Accounting is not in the list under Allowed Apps and Features, then click Allow another app.
- In the Add an app dialog box, find and select Sage 50 Accounting in the list.
You can also click Browse to locate Sage50Accounting.exe in your Sage 50 Accounting installation folder. Click Open and then 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
- Click OK.
If you need to make changes to Windows Firewall Advanced Settings, refer to Windows’ help for detailed information.
What are the 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.
How to check which firewall you’re using?
Using the following options, you can find out which antivirus or firewall software you use:
- Open Sage 50cloud Accounts and Go to Help > About.
- In the System Details section, look for the Firewall details.
- If the firewall details are not listed, open Start > All Programs and look for any anti-virus or firewall software in the list.
- You can also open Start > Settings > Control Panel and look for any antivirus or firewall software.
- Another way to check is to open Start > Run and type services.msc. In the Services list, look for any anti-virus/firewall software.
- Finally, you can use the mouse to hover over the system tray (normally found in the bottom right corner of your screen, next to the clock). Each option you hover over shows the name of the application that is running. Look for any antivirus or firewall software.
Here are some additional tips:
- If you are not sure which firewall you are using, you can ask your IT administrator.
- If you are using multiple firewalls, you will need to check each to ensure that Sage 50cloud Accounts can communicate through them.
- If you are having trouble connecting to Sage 50cloud Accounts, it may be because your firewall is blocking the connection. You can try adding Sage 50cloud Accounts to the list of allowed apps in your firewall.
URLs to Exclude from a Firewall
Firewalls and antivirus software can disrupt software updates. To reduce this problem, configure your firewall and antivirus to allow access to specific URLs. Below are some URLs:
| http://update.sage.com | https://ds.sage.co.uk/api/dataservices |
| https://update.sage.com | https://ds.sage.co.uk/dsmc |
| http://downloads.sage.co.uk | https://s3.amazonaws.com |
| http://download.sage.com | https://signon2.sso.services.sage.com |
| https://download.sage.com | https://licensing.services.sage.com/lic/services/LicenceService |
| https://drive.sage.com | https://eol.sage.co.uk/employer/index.html – if using Online Payslips |
| https://eol.sage.co.uk/filesandfoldersv1 | https://regulatory-reports.sagecompliance.com/public/v3 |
| http://regulatory-reports.sagecompliance.com/ | http://regulatory-reports.sagecompliance.com/ |
| http://www.tax.service.gov.uk/ | https://www.sagebankdrive.com/api/v1 |
| https://eu.sagebankdrive.com/api/v1 | https://www.sagetokenservice.com/api/v1 |
| https://api.sbc.sage.com |
Ports to Exclude from the Firewall
Make sure the following ports are open on your firewall so Sage Data Service won’t be blocked
| Sage Accounts v31 | 1. Sage 50 Accounts Control v31: TCP 34231 2. Sage 50 Accounts Service v31: TCP 32231 3. Sage Accounts v31 TCP 32331 |
| Sage Accounts v30 | 1. Sage 50 Accounts Control v30: TCP 34230 2. Sage 50 Accounts Service v30: TCP 32230 3. Sage Accounts v30 TCP 32330 |
| Sage Accounts v29 | 1. Sage 50 Accounts Control v29: TCP 34229 2. Sage 50 Accounts Service v29: TCP 32229 3. Sage Accounts v29 TCP 32329 |
| 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 |
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.
Sage 50 Firewall Ports To Allow on Windows OS
Users need to allow the following Ports in the 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.
Help for Troubleshooting Windows Firewall Issues with Sage 50
There are instances where a Windows Update error mistakenly appears as a Sage 50 Firewall issue, with the symptoms being the same. Thus, before you are assured that the issue is a firewall issue, you should examine the same against the Windows update issue.
To do this, you must check if the Windows updates are still pending. If yes, complete the process and see if the company file opens.
Our AccountsPro team of technical experts will help you to know the process of identifying whether an error is due to the end of Windows updates or because of the firewall blocking. To get in touch with our SAGE Accounting support, you can call our help desk number ☎+1-800-983-3087.
Do you know how Sage 50 Cloud Hosting helps?
Business owners always desire to keep a watch on the databases and check them against any kind of tampering. However, they are unable to be present within the premises all the time to make sure. If you, too, are suffering from the same situation, you can connect with our AccountsPro Sage 50 experts. They will introduce you to Cloud Hosting for Sage 50 services. Using the feature will let you monitor your company files and databases from any corner of the world at any time of the day and through any device available to you.
Frequently Asked Questions
How do I add Sage 50 accounting to Windows Firewall?
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, select Sage 50 Accounting from the list, and click Add.
How do I stop a firewall from blocking?
To manage the whitelist in the Windows Firewall, click Start, type firewall, and click Windows Defender Firewall. Click Allow a program or feature through Windows Firewall (or, if you’re using Windows 10, click Allow an app or feature through Windows Firewall).
How do you unfreeze Sage 50?
- Open the Windows Task Manager by holding down the Alt + CTRL + Del keys on your keyboard and clicking on Start Task Manager.
- Go to the Processes tab.
- Select Sage50Accounting.exe on the list.
- Click the End Process button.
- Open Sage 50 and try to open the same window. If the issue is fixed, stop here.
Why does my firewall keep blocking everything?
Why is this happening? This is most likely occurring because you have a misconfiguration of a Windows Firewall rule that is explicitly blocking whatever access or app you are using to browse the Internet on TCP port 80 or 443, or maybe even blocking an entire subnet that is required to access the network or Internet.
How do I find my firewall settings on Windows?
To turn on Windows Firewall in Windows, open the Control Panel, click on System and Security, and then click on Windows Firewall. If your firewall is disabled, it will be marked “Off.” In the left navigation pane, click on Turn Windows Firewall on or off. In the Customize Settings window, select the Turn on Windows Firewall option for Domain, Private, and Public networks. Click on OK to turn on your Windows Firewall.
