Hello all,

I'm trying to upgrade BES 4.1.6 for Domino BES 5 using a single server upgrade. But the upgrade fails during the SQL database upgrade. The following is the error statements from the log:

[30000] (10/19 22:46:35.023):{0x9E0} SQL being executed:
DELETE FROM BASMetaDataDefinitions WHERE PlugInId = 106
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(1,106,2,'QueryLimit',1,50,0,65535,1,null,nu ll,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(2,106,0,'EnableDataCompression',1,0,0,null, null,null,null,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, Def
[20000] (10/19 22:46:35.131):{0x9E0} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'rsaAuthSupport'." Native error = 207
[20000] (10/19 22:46:35.131):{0x9E0} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'rsaAuthSupport'." Native error = 207
[20000] (10/19 22:46:35.131):{0x9E0} [CBESDBInstaller::ExecuteDDL] SQL Error for:
DELETE FROM BASMetaDataDefinitions WHERE PlugInId = 106
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(1,106,2,'QueryLimit',1,50,0,65535,1,null,nu ll,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(2,106,0,'EnableDataCompression',1,0,0,null, null,null,null,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId
[10000] (10/19 22:46:35.131):{0x9E0} An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement.
[30000] (10/19 22:46:46.137):{0x17A0} <5>Oct 19 22:46:46 blackberry01 {0x1798} 0204: (#30000) [PIPTOOL]: Cancelling PIPTool from CDBInfoDlg.
[30000] (10/19 22:46:46.137):{0x17A0} <3>Oct 19 22:46:46 blackberry01 {0x1798} 0205: (#10000) [PIPTOOL]: Executing stop from CDBInfoDlg.
[40000] (10/19 22:46:46.137):{0x17A0} LogReceiver: Code on closing = 10038
[30000] (10/19 22:46:46.137):{0x17A0} [DIAG] EVENT=Unregister_thread, THREADID=0x17A0, THREADNAME="InstLogReceiver"

I have searched high and low for any indication, bu no luck.. Any help would be appreciated.

TIA

Are you using MSDE or SQL?

But would have no problem going to SQL Express 2005 or later