I have a 3100 appliance that I successfully upgrade to Windows 2008 using an appliance image on discs supplied by McAfee. The backup I took of the database prior to the upgrade restored correctly, and the system was up an running on MVM version 7.0 with no issues.
Then I attempted to do the upgrade to MVM version 7.5 but it keeps failing the database upgrade part of the process. I get a prompt saying "The upgrade of the Foundstone database has failed. Please resolve any issues identified in the database error log and retry the installation procedure again.". So I click OK, it prompts me to rety, and we go round the loop again.
I've looked through what I think is the installation log, and the extract below shows what I think is the source of the problem:
08/06/2012 12:08:38 Connecting to server '[server name]' by ADO succeeded in the 'InitDB()' call.
08/06/2012 12:08:38 GetDBVersion() call succeeded.
08/06/2012 12:08:38 The current version of FoundScan database 'Faultline' is '7.0.159'.
08/06/2012 12:08:38 calling RunPatchScripts.
08/06/2012 12:08:38 Run Patch 7.5.141
08/06/2012 12:08:38 Running script file 'D:\Foundstone\\DatabaseTemp\SupportFolder\Current\Patch\..\FLCreateFilesGroups .SQL' succeeded.
08/06/2012 12:08:38 Running script file 'D:\Foundstone\\DatabaseTemp\SupportFolder\Current\Patch\..\FLAddedRoles.sql' succeeded.
08/06/2012 12:08:39 Running script file 'D:\Foundstone\\DatabaseTemp\SupportFolder\Current\Patch\..\FLDataPopulation_fs sysFaultlineDefinitions.sql' succeeded.
08/06/2012 12:08:39 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the not equal to operation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at FoundstoneDBInstall.DBHelper.RunDBSQLScript(String scriptFileFullName)
08/06/2012 12:08:39 Running script file 'D:\Foundstone\\DatabaseTemp\SupportFolder\Current\Patch\..\FLDataPopulation_FS ErrorMessages.SQL' failed.
08/06/2012 12:08:39 FoundstoneDBInstall Critical method failed.
Anyone else come across this? Any solutions?!!