When trying to connect GFI WebMonitor 2012 to an already existing database, the following errors occurs:
error'System.ServiceModel.FaultException: There is already an object named 'Users' in the database' appears while reattaching a database in WebMonitor 2012.
The complete error is:
System.ServiceModel.FaultException: There is already an object named 'Users' in the database.
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object ins, Object outs, TimeSpan timeout)
- GFI WebMonitor 2012
- All supported environments
The error indicates that WebMonitor is trying to connect to an old Microsoft SQL database that was used for the GFI WebMonitor 2011 Report Pack (or earlier).
Under the Settings > General > Database page, enter the name of a database that does not exist on the Microsoft SQL Server and save the changes. This will create the a new GFI WebMonitor 2012 database.
Afterwards, you have the option to run the ..\GFI\WebMonitor\WebMonDataImporterTool executable to transfer the data from a WebMonitor 2011 firebird database (or 2009 SQLite databases) into the new WebMonitor 2012 database. See the following related article for further details: How to transfer data
The Microsoft SQL database used for reporting in older versions of GFI WebMonitor is incompatible with the GFI WebMonitor 2012 database schema and must be converted.