If you’re looking for details on which versions of SQL Server are supported for ConfigMgr 2007 then the System Center Configuration Manager team comes through again. Yesterday they published a post that not only discusses the various versions but the hotfixes required depending on what you choose to use. I have their intro and a link below:
As part of the planning considerations for Configuration Manager 2007 (ConfigMgr for short) deployment, we need to determine which version of SQL server will be used to host the site database. Before the release of SQL Server 2008 and later SQL Server 2005 SP3, the only SQL Server version supported to host the ConfigMgr site database was SQL Server 2005 SP2.
With the release of SQL Server 2008, the SQL support scenarios became a little complex. Hopefully, this post will clear things up and help you to figure out the right deployment or upgrade strategy.
Following is an overview of the Configuration Manager 2007 support for the different SQL Server versions…
J.C. Hornbeck | Manageability Knowledge Engineer