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'
- GFI WebMonitor
- Non-English Microsoft SQL Server Installations
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.
The following Microsoft SQL script can be used to change the collation of the GFI WebMonitor database:
ALTER DATABASE WebmonitorDatabase
WebMonitorDatabase should be replaced by the name of the GFI WebMonitor database.