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:
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.
- 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 !!