GFI WebMonitor fails to create a new database or 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 following Microsoft SQL script can be used to change the collation of the WebMonitor database:
ALTER DATABASE WebmonitorDatabase
NOTE: WebMonitorDatabase should be replaced by the name of the GFI WebMonitor database.
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 WebMonitor database can be changed by using the script above in order for WebMonitor to be bale to use the database.