After properly moving the Foglight remote database to another server (using a complete database backup/restore), Foglight will not start, and will report the following errors;
2011-03-04 08:31:44.044 ERROR [main] com.quest.nitro.service.upgrade.db.
DatabaseUpgradeService - Unable to determine the current database schema version.
com.quest.nitro.upgrade.UpgradeException: Unable to query the topology_type table.
2011-03-04 08:31:44.357 ERROR [main] org.jboss.deployment.scanner.
URLDeploymentScanner - Incomplete Deployment listing:
--- Packages waiting for a deployer ---
Permissions for the tables are set correctly, and user may have been given sa privileges with no change.
The database user ("foglight" by default) does not have its default database set to the Foglight database on the restored database.
Set the database user's default database to the Foglight database in SQLServer Manager.
This issue will also appear if the Foglight database was moved by a detach/attach process. This process is incomplete, and not supported as a method of moving the database. See SOL67446