locked
SCCM 2012 and SQL Server 2012 RRS feed

  • Question

  • Hello,

    My organization has SCCM 2007 R3 installed and working properly. It's currently using SQL Server 2008 R2. We would like to migrate from SCCM 2007 to 2012. Can I install SQL Server 2012 on my new server for SCCM 2012? The documentation doesn't specifically list SQL Server 2012 as being supported, however, I did see on the SCCM Team Blog that you could upgrade SQL to 2012 for SCCM 2007 R3 installations. Does this mean that SCCM 2012 supports SQL Server 2012 as well?

    Thank you in advance.

    Wednesday, April 25, 2012 4:46 PM

Answers

All replies

  • Hi,

    No, SCCM 2012 does not support SQL 2012 yet, it is only SCCM 2007 which supports SQL 2012 in an upgrade scenario..

    The supported configurations for SCCM 2012 are listed here: http://technet.microsoft.com/en-us/library/gg682077.aspx the blog post on sccm 2007 only covers SCCM 2007 and in an upgrade scenario.

    Regards,
    Jörgen


    -- My System Center blog ccmexec.com -- Twitter @ccmexec

    • Marked as answer by hhancock Wednesday, April 25, 2012 5:26 PM
    Wednesday, April 25, 2012 5:15 PM
  • Thank you for the clarification. Is there any specific timeframe on when and if SCCM 2012 will support SQL Server 2012? We really want to begin upgrading all of our SQL Server 2008 installations.
    • Edited by hhancock Wednesday, April 25, 2012 5:27 PM
    Wednesday, April 25, 2012 5:26 PM
  • As a general rule CM will support a product ~90 days after it is released.


    http://www.enhansoft.com/

    Thursday, April 26, 2012 11:50 AM
  • Just to clarify...

    90 days is not a promise or an SLA from Microsoft, but in the past thats what we've seen (~90 days).
    AFAIK, Microsoft havent even announced that this version of CM12 will ever support SQL 2012. (Not saying it wont, but so far no announcements on that part).

    So until they decide to let us know, we're all just guessing :)


    Ronni Pedersen | Configuration Manager MVP | Blog: http://www.ronnipedersen.com/ | Twitter @ronnipedersen

    Thursday, April 26, 2012 1:03 PM
  • All roles work in an unsupported scenario minus SSRS. I have not been able to get SSRS working most likely because they put in a check for the specific version of SQL, or I am doing something wrong (it could be either). I have a lab server that is running Server 2012 beta and all the System Center 2012 products. 
    • Edited by HSChronic Thursday, April 26, 2012 1:23 PM
    Thursday, April 26, 2012 1:22 PM
  • Actually, SQL 2012 uses a new WMI namespace for SSRS:

    root\microsoft\sqlserver\reportserver\rs_<instance>\v11

    For SQL 2008 and R2 it is v10.  When SSRS is called via WMI, as during CfgMgr's Reporting Point setup procedure, it only looks for the v10 namespace, and thus cannot find a SQL 2012 SSRS instance.

    Hopefully MSFT will add this ability with the first service pack for CM 2012!

    An alternate approach would be for the SQL team to release a "backwards compatibility" library for SSRS 2012.

    Wednesday, May 9, 2012 5:26 PM
  • Hi,

    Good to know upgrade is possible and MS supported scenario, however appreciate info on below points

    1. Is it supported and harmless to upgrade SQL to 2012 on child primary while central still runs SQL 2008 R2 (in SCCM 2007 hierarchy) ?
    2. I see these articles are needed for upgrade from SQL 2008 to SQL 2012( Article 2676776 & Article 2676737)…are they prerequisites for upgrade or break fix install of issues post SQL 2012 upgrade ?

    Thanks, Vasu


    Vasu

    Monday, July 23, 2012 7:25 AM
  • SQL 2012 is not yet supported so you should not upgrade! http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, July 23, 2012 8:03 AM
  • Hi Torsten,

    I see it is MS supported scenario to upgrade SQL from 2008 or R2 to SQL2012 on SCCM 2007 hierarchy. Ref: http://technet.microsoft.com/en-us/library/ee344146.aspx  

    Appreciate your thoughts on above questions accordinlgy


    Vasu

    Monday, July 23, 2012 8:56 AM
  • I see it is MS supported scenario to upgrade SQL from 2008 or R2 to SQL2012 on SCCM 2007 hierarchy. Ref: http://technet.microsoft.com/en-us/library/ee344146.aspx  

    Sure, but that's only true for CM07, not CM12 (and this is the forum for ConfigMgr 2012), so my statement is still true.

    Torsten Meringer | http://www.mssccmfaq.de

    Monday, July 23, 2012 9:19 AM