You are touching on a sore point I have with Amazing Charts. Amazing Charts is not supported on Windows Server 2022 and SQL Server 2022. Both have been out for some time yet AC does not support them.
My typical client set up is a single physical server with two virtual machines: the first virtual machine is the domain controller. The second virtual machine runs Amazing Charts and other applications as needed (QuickBooks, etc.). Unfortunately, while the host operating system and the domain controller are both Windows Server 2022, the Applications server (AC, Quickbooks, etc.) still has to be Windows Server 2019. An OS that is already almost 5 years old.
JamesNT