SQL 2008 – Is it supported on System Center Configuration Manager 2007?

  • Article

 

 

 

 

 

Our live event content this quarter includes System Center Configuration Manager 2007 and this has been a common question: “Is SQL 2008 supported as a site database?”

The Answer

Absolutely!!!!!    SQL Server 2008 is now supported on Configuration Manager 2007 RTM and SP1!

 

What Do I need to do to the Site Server?

In order to upgrade a site-server database to SQL 2008 you must first apply a hotfix.  Which one depends on what version of System Center Configuration Manager 2007 you’re running:

 

What if its a clean install of System Center Configuration Manager 2007 ?

That’s a little more complicated.  If you’re performing a clean install of SCCM using a SQL Server 2008 database, depending on whether is RTM or SP1, you will have to do the following steps:

Clean install of System Center Configuration Manager 2007 RTM:
    • NOT SUPPORTED
      1. First, install SQL Server 2005
      2. Upgrade to SQL Server 2008
      3. Apply hot fix KB955229
Clean install of System Center Configuration Manager 2007 SP1:
    • SUPPORTED
      1. Apply hot fix KB955262