Summary
Configure your antivirus and firewall to allow the necessary processes and ports to ensure that Sage 50 Accounting will operate correctly.
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 folder:
You only need to allow files that are specific to the Sage 50 version you’re installing.
- MySQL 8.0.27 for Version 2023.0 and higher
Files to exclude:
NOTE: If you chose a different install location other than the default program files location, substitute your custom location for C:\Program Files\Sage 50 [Your Product Solution] [Year]
- 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]\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\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 13540 - 13579
If you chose a different install location other than the default program files location, substitute your custom location for C:\Program Files\Sage 50 [Your Product Solution] [Year]\