Thursday, March 8, 2012

SQL Server 2012 is Now Officially Supported for Microsoft Dynamics CRM 2011 and Also 4.0

An interesting turn of events occurred yesterday.  Support for SQL Server 2012 in Microsoft Dynamics CRM 2011 was originally slated to be part of the Q2 2012 service update as noted at these locations:

 - http://crmpublish.blob.core.windows.net/docs/ReleasePreviewGuide.pdf

 - http://blogs.msdn.com/b/crm/archive/2012/03/07/microsoft-dynamics-crm-and-sql-server-2012-better-together.aspx

BUT.....  according to some super secret sources (along with these KB Articles :)  ), Microsoft will currently support SQL Server 2012 on both CRM 2011 and even 4.0 as of Update Rollup 6 and Update Rollup 21 respectively.

 - http://support.microsoft.com/kb/2669061

 - http://support.microsoft.com/kb/2686619


IMPORTANT NOTES:

- One item of note is that you need to re-install the data connector for both CRM 2011 and 4.0 after installation if upgrading otherwise reporting services will not work.

Just be warned, that it's not perfect yet and Microsoft is working on a couple of issues, but they will have hot-fixes out for these soon.  The issues below are both noted in the KB articles above.

 - One issue in 4.0 can cause reports not to be displayed and there isn't a workaround, but a hotfix is coming.

 - Lastly, in CRM 2011, there is still an issue they are working on that can cause the outlook client to fail when using SQL 2012.  A hotfix is also actively being worked on for this at this time also.


Happy Thursday Everyone !!

-

4 comments:

  1. Nice, thanks PS: I love this super secret sources :)

    ReplyDelete
    Replies
    1. Well, there were super secret sources that told me about it before the KB's were published, but I had to wait until the ink dried on the KB's to disclose. Before that it would have been under NDA.

      Delete
  2. who gives a toss if its secret or not. Its a product built by Microsoft for Microsoft's own products. SQL 2012 should have worked with Dynamics CRM straight out of the box. I bet Always on still doesn't work with Dynamics CRM 2011 and the latest rollup



    ReplyDelete