locked
SCCM 2012 R2 wSQL 2008 R@ - Upgrade to SQL 2012 SP2 RRS feed

  • Question

  • Hi

    Wanting to upgrade our site database from 2008 R2 to 2012 SP2

    Getting the error

    Configuration Manager requires Microsoft SQL Server ......

    You must upgrade SQL Server before installing Configuration Manager.

    Any ideas?  I'm moving to SQL 2012 SP2, so it meets requirements

    Monday, June 22, 2015 4:44 AM

Answers

All replies

  • Did you follow a guide like this one ? 

    http://blogs.technet.com/b/configurationmgr/archive/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server.aspx


    Or are you talking about an in place sql upgrade?  In that case have you checked out here

    https://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigUpgradeDBSrv


    Make sure you are installing 64 bit SQL

    Monday, June 22, 2015 1:12 PM
  • I am performing as per guide mentioned

    SQL Server 2012

    version 11.0.5058

    It isn't 64bit however

    Monday, June 22, 2015 9:48 PM
  • Hi,

    Configuration Manager requires a 64-bit version of SQL Server to host the site database.

    https://technet.microsoft.com/en-us/library/gg682077.aspx?f=255&MSPPError=-2147217396#BKMK_SupConfigSQLSrvReq


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by Daniel JiSun Tuesday, June 30, 2015 7:23 AM
    Tuesday, June 23, 2015 6:24 AM