STSv7 troubleshooting

If you see the following error logs, a problem likely exists with the compatibility level of your version of SQL Server and version 8 of EF Core.

Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near
        '$'.

To confirm if an error exists, run the following query:

SELECT compatibility_level FROM sys.databases WHERE name =
      'STSConfigurationV4';

EF Core version 8 requires a compatibility level of 130; if you are running a previous version, perform either of the following actions:

Run the following command for both of the STS databases to set the compatibility level to 130: ALTER DATABASE STSConfigurationV4 SET COMPATIBILITY_LEVEL = 130
- This is considered a short-term workaround; it is recommended to update SQL Server.
Update your version of SQL Server.