none
SCCM 2007 SP1 with SQL 2008

Answers

  • We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-)

     

    However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way.

     

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

    System Center Configuration Manager 2007 (RTM and SP1) now supports the use of SQL Server 2008 as a site database.  In order to upgrade a site-server database to SQL 2008 there are 2 hot fixes required:

    ·          ConfigMgr 2007 RTM customers must apply hot fix KB955229

    ·          ConfigMgr 2007 SP1 customers must apply hot fix KB955262

     

    The following are requirements when performing a clean install on a SQL Server 2008 database:

    ·          A clean install of ConfigMgr 2007 RTM on a SQL Server 2008 database is not supported.  You must first install SQL Server 2005, upgrade to SQL Server 2008 and then apply hot fix KB955229

    ·          A clean install of ConfigMgr 2007 SP1 on a SQL Server 2008 database is supported, but should apply hot fix KB955262

     

    We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-)

     

    However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way.

    Friday, September 26, 2008 8:01 PM

All replies

  • Not yet.

     

    Thursday, September 18, 2008 3:26 PM
    Moderator
  • SCCM 2007 SP1 does not work with SQL 2008 but I have successfully installed SCCM 2007 R2 with SQL 2008

     

    Friday, September 19, 2008 1:40 PM
  • We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-)

     

    However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way.

     

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

    System Center Configuration Manager 2007 (RTM and SP1) now supports the use of SQL Server 2008 as a site database.  In order to upgrade a site-server database to SQL 2008 there are 2 hot fixes required:

    ·          ConfigMgr 2007 RTM customers must apply hot fix KB955229

    ·          ConfigMgr 2007 SP1 customers must apply hot fix KB955262

     

    The following are requirements when performing a clean install on a SQL Server 2008 database:

    ·          A clean install of ConfigMgr 2007 RTM on a SQL Server 2008 database is not supported.  You must first install SQL Server 2005, upgrade to SQL Server 2008 and then apply hot fix KB955229

    ·          A clean install of ConfigMgr 2007 SP1 on a SQL Server 2008 database is supported, but should apply hot fix KB955262

     

    We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-)

     

    However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way.

    Friday, September 26, 2008 8:01 PM
  • Have there been any updates to this yet or is the above information still the latest?

     

    Wally, is this published anywhere else on Microsoft's site?

     

    Currently this now out-dated information is still posted on TechNet...http://technet.microsoft.com/en-us/library/bb694113.aspx

    Site Database Server Prerequisites

    Configuration Manager 2007 primary sites require access to a SQL Server database to host the site database. The site database can be hosted on a SQL Server instance installed on the same server as the primary site, on a remote computer, or on a virtual SQL Server cluster instance. The following conditions apply:

    • SQL Server 2005, Service Pack 2 is the only version of SQL Server supported for hosting the Configuration Manager 2007 site database.
    • SQL Server 2005 Express is not a supported SQL Server 2005 version for hosting the Configuration Manager 2007 site database.
    • The SQL database service is the only SQL Server component required to be installed to host the site database.
    Wednesday, October 22, 2008 1:35 PM
  • Documentation does not get immediately updated. I've heard that the next doc drop is not until December.

     

    So yes, as far as I know the information above is the most current. What is it that you are looking for exactly?

    Wednesday, October 22, 2008 4:26 PM
  • I'm just looking for the official word that SCCM 2007 supports SQL 2008 that I can present to management.  I will just reference your post.  Thanks for getting back with me.

    Monday, October 27, 2008 1:34 PM
  • I'm not entirely sure why we only updated the Supported Configurations documentation to state we support Windows Server 2008, but not to reflect SQL Server 2008. I know the support came quite awhile apart, but seems to be a gap to me.

     

    Sorry that we haven't done so :-(

    Monday, October 27, 2008 7:51 PM
  • Wally, is this still the most current data?
    "However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way."

    Thanks, Duncan

    Duncan McAlynn, MVP/MCSE/MCSA/CISSP
    Tuesday, February 24, 2009 5:23 PM
  • Based on the following statement, I'm going to assume that it is supported with the applied hotfix:

    "2
    When SQL Server 2008 is used to host the site database for a Configuration Manager 2007 R2 installation, it is recommended that you install the update described in Microsoft article ID 957576 located at http://go.microsoft.com/fwlink/?LinkId=134675."

    Source: http://technet.microsoft.com/en-us/library/cc161851.aspx

    Duncan McAlynn, MCSE/MCSA/CISSP
    Tuesday, February 24, 2009 7:24 PM
  • Hi,

    Please also take a look at the following thread regarding SQL 2008 support:
    http://social.technet.microsoft.com/Forums/en-US/configmgrdocs/thread/1763c6fa-aa46-4c0f-b9db-9dba34f163b2


    Please mark posts as Answered if appropriate.
    Tuesday, February 24, 2009 9:18 PM
  •  
    DuncanMc said:

    Wally, is this still the most current data?
    "However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way."



    No, it is not. We do now support Configuration Manager 2007 R2 with SQL Server 2008.
    Wally Mead
    Monday, March 09, 2009 7:36 PM
  • Would that include a clustered SQL 2008 configuration?
    Duncan McAlynn, MCSE/MCSA/CISSP
    Monday, March 23, 2009 4:30 PM
  • DuncanMc said:

    Would that include a clustered SQL 2008 configuration?


    Duncan McAlynn, MCSE/MCSA/CISSP



     Yes, SQL Server 2008 supports the same features for Configuration Manager as SQL Server 2005 SP2.
    Wally Mead
    Tuesday, March 24, 2009 4:58 PM
  • The Hotfix page for  KB955262 does not allow request any longer. Where do people get it, as the link states no public fixes for it are available.

    Thanks
    David Baur

    David Baur
    Wednesday, May 13, 2009 1:29 PM
  • Does the Hotfix for 969529 supercede 955262?
    David Baur
    Wednesday, May 13, 2009 1:48 PM
  • Does the Hotfix for 969529 supercede 955262?
    Yes, according to the download section in premier.microsoft.com.
    Edit: I just installed 969529 on a brand new ConfigMgr site and it also solved the issue that the drivers node was not displayed.
    • Proposed as answer by David Baur Thursday, May 14, 2009 11:55 AM
    Thursday, May 14, 2009 6:49 AM
    Moderator
  • I thought it would, Thanks Torsten!

    David Baur
    David Baur
    Thursday, May 14, 2009 11:55 AM
  • You know if you would have posted this as a new thread in the proper forum (such as General or Setup/Deployment) people might have gotten on it earlier :-)

    Not sure how this is an announcement :-)

    But yes, 969529 replaces 955262. The KBs are being updated to reflect that.
    Wally Mead
    Wednesday, May 20, 2009 11:39 PM
  • Many Thanks Wally,

    David Baur
    David Baur
    Thursday, May 21, 2009 2:33 PM
  • Hi Wally,

    what can I do if I installed SCCM R2 and forgot to install KB969529 first?
    The 969529 installer tells me that this is the wrong build number. I assume 969529 can only update SP1 but not R2?
    Please don't tell me to install SP2 as i have a german version and SP2 is not yet available in german.

    Thanks,
      Dieter
    Tuesday, October 27, 2009 5:47 AM
  • Hi,

    in the meantime i could successfully resolve this issue.
    The "wrong build number" referred to the Windows Version (not SCCM), as I was installing on Server 2008 R2.
    So better wait for SCCM SP2, as 969529 cannot be installed on Server 2008 R2. (I know this is not fully supported...)
    I manually replaced the files and executed the SQL script, works like a charm.

    Dieter
    Wednesday, October 28, 2009 11:01 AM
  • And just so everyone knows, we *do not* support Windows Server 2008 R2 as a site system with Configuration Manager 2007 RTM or SP1. It is only supported as of SP2.
    Wally Mead
    Friday, October 30, 2009 11:07 PM
  • I know SCCM 2007 can run on SQL 2008. But can it run on SQL 2008 SP1?

    Monday, December 21, 2009 10:12 AM
  •  But can it run on SQL 2008 SP1?
    Let's see what the docs are telling us ... http://technet.microsoft.com/en-us/library/ee344146.aspx -> SQL Server Site Database Configurations, so yes SQL 2008 SP1 is supported.
    Monday, December 21, 2009 1:06 PM
    Moderator
  • Thanks, once again!
    Tuesday, December 22, 2009 9:13 AM
  • Does anyone know if there is a doc for SQL Reporting Services Point Setup for 2008 SQL?  I have been searching for one with no luck so far.  I keep getting  the following error and I am pretty sure it's the reporting services setup is wrong on the sql server.

    SRS root folder "ConfigMgr_XXX" is not present or not properly configured SRS Reporting point server "reportingserver".

    Please let me know if anyone knows where a doc to help me set this up, thanks!!!

    Monday, October 18, 2010 3:40 PM