Overview

This article describes the process to follow when the GFI WebMonitor fails to create a new database or fails to connect to an existing database with the following error message:

Database Error: Invalid column name 'Items'

Information

Environment

• GFI WebMonitor
• Non-English Microsoft SQL Server Installations

Root Cause

The GFI WebMonitor requires the database collation to be Latin1_General_CI_AS and this error is encountered when the database collation is different. The collation for the GFI WebMonitor database can be changed by using a script in order for the GFI WebMonitor to be able to use the database.

Process

The following Microsoft SQL script can be used to change the collation of the GFI WebMonitor database:

USE master;
GO
ALTER DATABASE WebmonitorDatabase
COLLATE Latin1_General_CI_AS;
GO

NOTE: WebMonitorDatabase should be replaced by the name of the GFI WebMonitor database.