Skip to content
logo Knowledgebase

Which processes and ports do I need to allow through my anti-virus / firewall to ensure that Sage 50 Canadian Edition will operate correctly?

Created on  | Last modified on 

Summary

This article lists all the executables and ports, needed for the program to open or function.

Resolution

CAUTION: This solution requires advanced knowledge of your network. Contact your system administrator for assistance. Modifying Windows security incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows security. Always create a backup of your data before proceeding with advanced solutions. 



MySQL folders:

  • You only need to allow the files that are specific to the Sage 50 version you are installing.
    • MySQL 5.0.38 is for Version 2008 - 2013
    • MySQL 5.6.10 is for Version 2014 - 2017
    • MySQL 5.7.18 for Version 2018 - 2019
    • MySQL 5.7.27 for Version 2020.1 - 2022.3
    • MySQL 8.0.27 for Version 2023.0 and higher
      • Eg. If you are trying to get 2020.1 to function properly, you will not need to permit the MySQL file in the MySQL 5.6.10 folder

These files must be excluded:

  • C:\Program Files (x86)\Sage 50 Accountant Edition\Sage50Accounting.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\SimplyConnectionManager.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.0.38\mysql\mysql.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.0.38\mysql\mysqld-nt.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10\mysql\mysqladmin.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10\mysql\mysqld.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysqlcheck.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysqld.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysqladmin.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.27\mysql\mysqld.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.27\mysql\mysqladmin.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqld.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqladmin.exe
  • C:\Program Files (x86)\winsim\TransactionManager20XX – CDN\Sage_SA.TransactionManager.exe
  • C:\Program Files (x86)\Sage 50 [version]\dbverifier\Sage_SA_DBVerifier.exe
  • C:\Program Files (x86)\Sage 50 [version]\LogSubmitter\Sage_SA_ErrorLogSubmitter.exe
    • this file is only up to 2016 version
  • C:\Program Files (x86)\Sage 50 [version]\Sage_SA_dbutil.exe
  • C:\Program Files (x86)\Sage 50 [version]\Sage_SA_Policy.exe
  • C:\Program Files (x86)\Sage 50 [version]\Sage_SA_update.exe
  • C:\Program Files (x86)\Sage 50 [version]\Sage_SA_webhelp.exe
  • C:\Program Files (x86)\Sage 50 [version]\Sage_SA_upload.exe
  • C:\Program Files (x86)\Sage 50 [version]\SageUpgrader.exe
  • C:\Program Files (x86)\Sage 50 [version]\Sage_SA_custrep.exe
  • C:\Program Files (x86)\Sage 50 [version]\TST\Sage_SA_TST.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\Simply.SystemTrayIcon.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.0.38\mysql\mysql.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.0.38\mysql\mysqldump.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10\mysql\mysql.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10\mysql\mysqldump.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysql.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.18\mysql\mysqldump.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.27\mysql\mysql.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.7.27\mysql\mysqldump.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysql.exe
  • C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\8.0.27\mysql\mysqldump.exe

The following ports must be available in your firewall security software that hosts the data:

  • Connection Manager: port 13531
  • MySQL: ports from 13540 to 13579


How to configure your Windows Firewall for network connectivity
Which software firewall am I using?
How to add exceptions to Windows firewall?

Chat with support