CRM 4.0 and SQL 2012 RRS feed

  • Question

  •  I am advising a site which has a very large CRM 4.0 system and needs to move to a new SQL server. We want to run SQL 2012 on this but although the rollups for CRM 4.0 include 2012 support there is said to be an issue with reporting as mentioned in


    which was supposed to be fixed by a later hotfix after Rollup 21 (link http://www.microsoft.com/en-gb/download/details.aspx?id=28799) which was released in February 2012.

    But I can find no link to any subsequent hotfix.

    Can anyone shed light on this?



    Tuesday, January 14, 2014 12:33 PM

All replies

  • Hi Paul,
    the Mainstream support for CRM 4.0 ended 9 April 2013 (there is still the Extended support), this means (I don't remember if I read an official communication about this) that no rollups will be released for CRM 4.0
    You can find the dates here:


    and also this post has some advises: (end of the article)


    Future Updates for CRM 4.0 (after Rollup 21)

    Due to the low volume of fix requests for CRM 4.0, the CRM SE team will stop shipping CRM 4.0 rollups on a regular schedule. 
    CRM SE will service CRM 4.0 requests on an individual basis using our Critical On-Demand process. 
    CRM SE will continue to evaluate the need for Update Rollups for the remainder of CRM 4.0’s supported lifecycle.

    If your system must migrate to SQL 2012, I suggest to clone your actual environment and try the update and test if the issue will be present in your system.

    Hope it helps

    My blog: www.crmanswers.net - Rockstar 365 Profile

    Tuesday, January 14, 2014 12:49 PM
  • Hi Guido

    Thanks for this fast response. It is just that Microsoft referred to a hotfix but probably never released it.

    I think we'll either have to try it out or go with SQL 2008 R2.



    Tuesday, January 14, 2014 1:04 PM