Microsoft are gearing up for the big new release later this year by releasing SQL Server 2012 and making it compatible with CRM 2011. The link below goes into detail about the big release
So How did I find out about SQL Server 2012 being compatible with CRM 2011, well a couple of sources.
Jamie Miley sums up the changes and has links to the relevant support pages in his blog
He has some interesting information on a couple of potential problems with the CRM 2011 and SQL Server marriage.
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.
I found some information from the excellent blog Dynamics CRM in the field, this is the blog written by Dynamics CRM service team and has some excellent technical information. Click the link below to find links to SQL Server 2012
This blog has some key information in it.
Firstly you need to be on at least rollup 6.
It also has some links to problems which might occur when upgrading to SQL Server 2012 – http://support.microsoft.com/kb/2686619
if you want to know what benefits you will get by using SQL Server 2012 with CRM 2011 then you can read the Microsoft blog below and it will show you the new reporting and other benefits
Personally I will be waiting until CRM 2011 and SQL Server 2012 has been tested a bit more thoroughly before I consider getting this up and running but releasing this to the CRM community will certainly speed things along.