Guys I got this error while upgrading SMS to SCCM , SQL is in Windows auth mode and I ran testdbupgrade and it was successful . Can any one help please ..
<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'UpdateSource_ID'.
<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MinScanPackageVersion'.
<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'UpdateSource_ID'.
<07-13-2013 00:36:39> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MinScanPackageVersion'.
<07-13-2013 00:36:39> SqlExecute < IF EXISTS(select * from SMSData where SMSBuildNumber < 5300) AND OBJECT_ID('CI_UpdateCIs') IS NOT NULL
BEGIN
IF OBJECT_ID('tempdb..##TempCIUpdateSources') IS NOT NULL
BEGIN
drop table ##TempCIUpdateSources
END
EXEC(' CREATE TABLE ##TempCIUpdateSources (CI_ID int,UpdateSource_ID int, MinScanPackageVersion int)
insert into ##TempCIUpdateSources (CI_ID, UpdateSource_ID, MinScanPackageVersion)
select CI_ID, UpdateSource_ID, MinScanPackageVersion from CI_UpdateCIs where UpdateSource_ID is not null and MinScanPackageVersion is not null')
END
>
<07-13-2013 00:36:39> Cannot execute sql command IF EXISTS(select * from SMSData where SMSBuildNumber < 5300) AND OBJECT_ID('CI_UpdateCIs') IS NOT NULL
BEGIN
IF OBJECT_ID('tempdb..##TempCIUpdateSources') IS NOT NULL
BEGIN
drop table ##TempCIUpdateSources
END
EXEC(' CREATE TABLE ##TempCIUpdateSources (CI_ID int,UpdateSource_ID int, MinScanPackageVersion int)
insert into ##TempCIUpdateSources (CI_ID, UpdateSource_ID, MinScanPackageVersion)
select CI_ID, UpdateSource_ID, MinScanPackageVersion from CI_UpdateCIs where UpdateSource_ID is not null and MinScanPackageVersion is not null')
END
<07-13-2013 00:36:39> Setup cannot upgrade the ConfigMgr database. Contact your SQL administrator.