If you are on-prem and dragging old installs one version to the next make sure you update your SQL Compatibility level of the database along the way. We are testing 2024.2 and found that we were unable to login and got all sorts of crazy errors. After @hkeric.wci enabled Serilog on the application I found that SQL was throwing an exception for OPENJSON command. It was introduced in 2016. Our database has been dragged up since 2011 when we went live and was still in 2014 compatibility mode.
9 Likes