Sage 50 Firewall Errors | +1-866-973-9785

How to Fix Firewall Problem During Install, Update Sage 50

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

Users of Sage 50 accounting software get access to a number of useful tools and features that make it easy to carry out all accounting and payroll tasks.

There are instances, though, in which the software execution is halted by specific technological faults. You may have heard that a software fault develops when the firewall prevents it from functioning. The most frequent technical problem that you might experience is a Sage 50 firewall error.

The AccountsPro team is made up of numerous experts who have acquired expertise in addressing Sage 50 mistakes. You can get in touch with them whenever you want help with software-related problems.

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

When you attempt to open your company file locally, an error occurs. The error message might read, “Sage 50 detected a firewall which may be blocking files also required by Sage 50,” in addition to the actual error.

How to Fix Sage Firewall Problems?

There are a few things you may take to solve the issue if your Sage 50 firewall is malfunctioning. Make sure your firewall software is updated to the most recent version first. Try rebooting both your firewall and PC next. You might need to use the methods listed below to assist you debug the problem if these solutions don’t work.

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

Your machine is secured by Windows Firewall, a technology that prevents unauthorised access. Using the Windows Update service, you may automatically update Windows Firewall. Your computer protection will stay current as a result.

  • 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

You can contact our Sage 50 support team if you believe you are having trouble completing the steps. You will be able to manage the problems effectively thanks to the technical team of professionals there.

Set Up the Windows Firewall for Sage 50 Accounting

To make Sage 50 Accounting function with your firewall configuration:

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.

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

Windows 10

  • Click Start and type firewall.
  • Click Windows Defender Firewall.
  • Click Allow an app or feature through Windows Firewall on the left side.
  • If Sage 50 Accounting is not in the Allowed apps and features list, click Allow another app.
  • Select Sage 50 Accounting from the list and click Add.
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
    • 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
    • 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 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
    • 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 2019

  • Open the Start menu > select Settings > 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
    • 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.

Help With Sage 50 Windows Firewall Issue Troubleshooting

Because the symptoms are the same, there are times when a Windows Update error incorrectly presents as a Sage 50 Firewall problem. Therefore, you should compare the problem with the Windows update problem before you are certain it is a firewall problem.

You must first see if the Windows updates are still pending in order to proceed. If so, finish the procedure and check to see if the business file opens.

Our AccountsPro team of technical specialists will assist you in determining how to determine whether a problem is caused by terminating windows updates or by a firewall blocking. Call our help desk at (+1-866-973-9785) to speak with a member of our SAGE Accounting support team.

Do You Know How Sage 50 Cloud Hosting Can Be Useful?

Business owners always want to monitor the databases and look for any signs of tampering. However, they are unable to constantly remain on the property to be sure. You can contact our AccountsPro Sage 50 professionals if you are experiencing the same problems. They’ll introduce you to providers for cloud hosting for Sage 50. By utilising the feature, you’ll be able to keep an eye on your business’s files and databases from anywhere in the world, at any time of the day, and using any device you have at your disposal.



Leave a Reply