Just out of curiosity how did you fix the connection issue? I had to re-install SAM completely fresh as it wont accept any new songs to be added to the category or the database. Tried the solution "extended repair" on HeidiSQL, however nothing was fixed.
I even tried uninstalling the original MariaDB database and replaced it with MySql, however SAM 2021.5 was stubborn to connect to MySQL even though there was a clean uninstallation of SAMBC. Finally I had to revert back to MariaDB and it works fine so far.
Hi there, I ended up installing VMWare Workstation and creating a Windows 2019 Server VM and installing SAM there from scratch, same as you did - it went without a hitch. I just won't be installing SAM on Windows 10 going forward, I've just had way too many problems trying to install lit on Windows 10. Then I created a 2019 VM for my MySQL server, and another 2019 VM for my web server. I love this configuration, my sites are lightning fast, easy to care for, and VMWare runs unobtrusively in the background on top of Windows 10.