Dom Posted February 20, 2009 Report post Posted February 20, 2009 Hello, "" Severity Type Site code Date / Time System Component Message ID Description Error Milestone SVR 2/20/2009 4:03:21 PM CONFIGMGRSVR SMS_COLLECTION_EVALUATOR 620 Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][ODBC SQL Server Driver] Invalid column name 'Decommissioned0'. Please refer to your SMS documentation, SQL documentation, or the Microsoft Knowledge Base for further troubleshooting information."" I have this error on all the servers just installed with SCCM???Is it normal on new servers? Thanks Quote Share this post Link to post Share on other sites More sharing options...
anyweb Posted February 21, 2009 Report post Posted February 21, 2009 nope, what version of SQL did you install ? Quote Share this post Link to post Share on other sites More sharing options...
wmmayms Posted February 24, 2009 Report post Posted February 24, 2009 I currently don´t have access to my laboratory (moving it). But i would start by checking that my "Decommissioned0" Column was spelled correctly in my dbo.v_R_System. To do this log on your SQL Server Open Management Studio (SQL 2005) or Enterprise Manager (SQL 2000) Expand your SMS Database Expand Views Find the view called "dbo.v_R_System". Check that the Column "Decommissioned0" is named correctly. Here is a pickture from a SMS 2003, SQL 2000 Enviroment. Btw are you performing a clean install of SCCM or are you trying an upgrade from SMS 2003? Do you have more then one DB server or what do you mean by? I have this error on all the servers just installed with SCCM??? Allso check your colleval.log (can be found on "<SCCMSERVER>\\<SCCM DIRECTORY>\LOGS") if you find any relevant information regarding this error. Quote Share this post Link to post Share on other sites More sharing options...
