“Incorrect syntax near ‘.’” when attempting to monitor MSSQL instance (4316708)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title