Upgrade SQL 2008 R2 to SQL 2012 in CRM 2011 RRS feed

  • Question

  • Hi,

    We are using CRM 2011 with service pack 11 on SQL 2008 R2. I want to upgrade SQL from SQL 2008 R2 to SQL 2012.  Please let me know is there any service pack of CRM I have to install for this, what is compatible SP of CRM 2011 for SQL 2012. Please help and provide the detailed documents those I have to follow to do this task.




    Monday, February 15, 2016 7:22 AM

All replies

  • Hi Noushad,

    According to https://support.microsoft.com/en-us/kb/3005163 it is supported as of UR6, with four asterisks that isn't explained.

    Hope it helps.

    Rickard Norström Developer CRM-Konsulterna
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Monday, February 15, 2016 12:05 PM
  • Hi,

    Thanks for your response and help.

    I want to upgrade SQL Server 2008 R2 to SQL Server 2012 in CRM 2011, service pack SP10 Update Rollup on server Windows server Enterprise R2, SP1.  I came to know that there is known issue as explained below.

    • After upgrading to Microsoft SQL Server 2012 you will need to reinstall the Microsoft Dynamics CRM Reporting Extensions. The custom binaries do not get brought over during the upgrade so the Microsoft Dynamics CRM Reporting Extensions need to be reinstalled.

    The CRM 2011 SRS component installer fails with the error: Column
    ‘DatacenterId’ does not exist on table Server. There appear to be 2 versions of
    the CRM install packages (RTM, and RTM + Rollup 6). If you try to use the RTM
    SRS installer with SQL 2012, you get a lot of errors.

    Will I get the same error I use CRM install packages  RTM + Rollup 6 or Download the new installation media version 05.00.9690.1992.  I do not want to reinstall CRM.   The current version of [MSCRM_CONFIG].[dbo].[ConfigurationMetadata] as mentioned below




    Please let me know still I have to get the below error and how can upgrade without any errors. Should I reinstall CRM.




    Wednesday, February 24, 2016 8:26 AM