Return
-
Title
“Incorrect syntax near ‘.’” when attempting to monitor MSSQL instance -
Description
When attempting to monitor a Microsoft SQL Server (MSSQL) instance, using the Foglight for Databases DB discovery wizard, the following error is displayed:
Failed to monitor x.x.x.x. Error: [Foglight][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ‘.'
The agent installer logs state the following:Next Exception #2 (previous: 1, caused-by level: 0): java.sql.SQLException: [Foglight][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'revert'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. -
Cause
Incorrect compatibility level set on the database (80 instead of 100, for example). -
Resolution
Ensure the MSSQL DB compatibility level is set to 100. If the current compatibility level is set to, for example, 80, this issue will manifest.