I'm trying to install Estimating on a Windows 11 computer. I can't use SQL14. It won't allow me to manage it at all. So I've installed a newer version of SQL. When I go through the setup, licensing is good, then when it checks the DB it tells me the Collation for the database is incorrect.
According to their documentation, I'm supposed to use SQL_Latin1_General_AS_CS. That specific collation is not available. I tried SQL 2017 and 2022. The closest is SQL_Latin1_General_CP1_AS_CS.
The setup will not allow me to continue. Is there a way around this?
Thank you for your help!