ConfigMgr 2007: SQL Server 2008 is now officially supported

  • Article

I don't think I saw anything about this but since the hotfixes have gone public I might as well give it a little pub here.  With the release of the hotfixes below, SQL Server 2008 is now supported on System Center Configuration Manager 2007 RTM (the released version) and SP1 (the Service Pack 1 version).  In order to upgrade a site-server database to SQL 2008 there are 2 hotfixes required:

  • ConfigMgr 2007 RTM customers must apply hotfix KB955229
  • ConfigMgr 2007 SP1 customers must apply hotfix KB955262

The following are requirements when using a SQL Server 2008 database:

ConfigMgr 2007 RTM

If you're running the original, RTM version of Configuration Manager, then you must first install Configuration Manager 2007 using SQL Server 2005, then install hotfix KB955229, then upgrade the site databases to SQL Server 2008.  The hotfix referenced must be installed on the following servers:

    • Primary site servers that are using SQL Server 2008 to host the database
    • Secondary site servers that report to primary sites that are using SQL Server 2008 to host the database
    • Servers that have the Configuration Manager 2007 console installed and connected to a site that uses SQL Server 2008 to host the database
    • Servers that host a remote SMS provider

ConfigMgr 2007 SP1

If you're running the Service Pack 1 version of Configuration Manager 2007 then you should apply hotfix KB955262 prior to upgrading SQL Server to the 2008 version. Apply this hotfix on the following servers:

    • Primary site servers that are using SQL Server 2008 to host the database
    • Servers that have the Configuration Manager console installed and that connect to a site that uses SQL Server 2008 to host the database
    • Servers that host a remote Systems Management Server (SMS) provider

I should also make it clear that while this is in fact supported, official documentation may not be posted for a little while.  As soon as it goes live I'll make sure to mention it here.

For more information see the corresponding Knowledge Base articles above.

J.C. Hornbeck | Manageability Knowledge Engineer