Installing the Foglight Management Server with an external SQL Server Database is failing with the following error messages:
Creating the database...
Database Install Failed
DB Creation Error: An error occurred while creating the database. It may be caused by insufficient disk space or insufficient permissions.
We did not find any disk space or permission issues so we installed the database manually.
Starting the FMS then failed and we observed these messages in the FMS log:
2013-03-05 13:11:07.422 ERROR [main] com.quest.nitro.service.spring.SpringBootstrapService - An unexpected error occurred which may cause undesired behavior. You may want to contact Quest Software customer support if you see this error again: Caught exception while starting. Initiating shutdown.
..
Caused by: org.jboss.tm.JBossRollbackException: Unable to commit, Batch update returned unexpected row count from update [0]; actual row count: -1; expected: 1
This was due to the “NOCOUNT" option being turned ON globally for the DB. The 'foglight' schema created by Foglight inherited this value. This prevented any row counts from being sent back to the server and as a result, the server failed to start up.
