update SMS to SCCM / Setup cannot upgrade the ConfigMgr database. Contact your SQL administrator
get following message in the setup.log : <12-29-2009 10:42:50> Beginning script execution. <12-29-2009 10:42:51> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'UpdateSource_ID'. <12-29-2009 10:42:51> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MinScanPackageVersion'. <12-29-2009 10:42:51> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'UpdateSource_ID'. <12-29-2009 10:42:51> ***SqlError: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MinScanPackageVersion'. <12-29-2009 10:42:51> 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 > <12-29-2009 10:42:51> 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 <12-29-2009 10:42:51> Setup cannot upgrade the ConfigMgr database. Contact your SQL any help welcome thanks
December 29th, 2009 1:43pm

Here you go!!! http://verbalprocessor.com/2009/12/02/setup-cannot-upgrade-the-configmgr-database/
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 11:52am

Hi Teddy, Did you manage to solve the problem? Can I close the thread?Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
January 15th, 2011 2:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics