As is always the case with me, I have been dying to install SQL Server 2012 to get “acquainted” with the new features and functions and how it will impact Microsoft CRM 2011.  I had been holding off because for some reason I was under the mistaken belief I couldn’t upgrade SQL and use it with the current Rollup of CRM 2011.  I thought I would have to wait until Rollup 8 was released.  I was absolutely wrong!

After doing some research, I discovered as long as you are running Rollup 6 or greater for CRM 2011 you can upgrade your SQL Server instance to 2012.  By the way, if you are still using CRM Version 4.0 don’t worry, as long as you are running Rollup 21 or greater you can update your instance of SQL Server to 2012 also.

One last note after you upgrade your SQL Server instance and the 2012 Reporting Services you will have to install or re-install the Reporting Connector for Version 4.0 or the Reporting Extensions for 2011.

I happened across a few helpful resources to get you started:

–        To download a trial copy of SQL Server 2012 Click Here

–        More information on CRM 2011 and SQL Server 2012 Click Here

–        For Support of Microsoft Dynamics CRM and SQL Server 2012 Click Here

–        For a compatibility matrix of Microsoft CRM and Related Technologies Click Here

Happy CRMing!

Steven