Close Menu
    Facebook X (Twitter) Instagram
    Sunday, October 12
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM 2007 SP2 and R3 support Microsoft SQL Server 2012 (upgrade)

    SCCM 2007 SP2 and R3 support Microsoft SQL Server 2012 (upgrade)

    Eswar KonetiBy Eswar KonetiApril 18, 2:26 pm2 Mins Read SCCM 2007 482 Views
    Share
    Facebook Twitter LinkedIn Reddit

    We are announcing support changes for the following releases. Please look for these changes to be reflected in the Supported Configuration pages within a few months.

    System Center Configuration Manager 2007 SP2 and R3 support Microsoft SQL Server 2012 (upgrade):

    System Center Configuration Manager 2007 SP2 and System Center Configuration Manager 2007 R3 now support upgrading an existing site database to Microsoft SQL Server 2012. 

    The Reporting Services Point site system and Client Status Reporting feature in System Center Configuration Manager 2007 R3 are also supported with SQL Server 2012.

    To use SQL Server 2012 for the site database, you must upgrade the instance of SQL Server in use at a site from SQL Server 2008 or SQL Server 2008 R2 to SQL Server 2012.  It is not supported to install a new Configuration Manager 2007 SP2 site with SQL Server 2012. It is also not supported to install Configuration Manager R3 when SQL Server 2012 is in use for the site database.

    The following software updates are required to use SQL Server 2012 to host the site database:

    • System Center Configuration Manager 2007 SP2 does not run some procedures because of a syntax change in the RAISERROR statement after you upgrade to SQL Server 2012 http://support.microsoft.com/kb/2676776
    • SSRS does not work after you upgrade SQL Server to SQL Server 2012 in System Center Configuration Manager 2007 R3 http://support.microsoft.com/kb/2676737

    --Harini Muralidharan

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Reference Via http://blogs.technet.com/b/configmgrteam/archive/2012/04/17/configuration-manager-support-announcements-for-april-2012.aspx

    configmgr configuration Manager SCCM SCCM 2007 SP2 and R3 support Microsoft SQL Server 2012 SCCM SP2 sql server 2012 supports SCCM supports SQL Server 2012 SQL Server supported configurations
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    2 Comments

    1. Ismail on January 12, 2016 5:03 AM

      Hello Eswar,

      Is there any prerequisite required for upgrading SCCM 2007 SP2 clients( 4.00.6487.2000)to CM 2012 R2 version(5.00.7958.1000) ?

      Reply
      • Eswar Koneti on January 27, 2016 12:43 AM

        No,there is no prereq ,you can simply install the new version which takes care of removal of old client and install new one.

        Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2025 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.