Summary
Resolution
CAUTION: This solution requires advanced knowledge of Windows security and network settings. Sage isn't responsible for any issues that may arise from changes to these settings. Back up all system and application databases needed for a complete restoration. Consider contacting a certified consultant or your system administrator for assistance.
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]\
Need more help?