Someone asked if Microsoft Dynamics CRM 2011 was compatible with SQL Server 2012 SP2, now this is quite
Many people mistakenly (initially) think all Microsoft products will be compatible with each other because they are the same company.
The reality is most of the Microsoft products are great big teams working separately. When a new product version come out, Microsoft internal teams probably have early access but it still takes time to fix and test different versions to give them the official compatibility stamp.
Customers want the stamp, you want the official stamp
Unsurprisingly Customers and all companies would like the official Microsoft compatibility stamp because then if there are problems Microsoft endeavours to fix them, if Microsoft hasn’t given the official compatibility stamp then you don’t know how long Microsoft will take to fix it.
They can be made to work
When a new version of SQL Server or patch is releasd you will often find the Microsoft Dynamics CRM community will soon try and install CRM on it (I don’t believe anyone has got it working with a raspberry PI yet but it’s surely only a matter of time).
They often find with a bit of pushing, pulling and brute force you can get incompatible versions working.
This is possibly acceptable for development environments but don’t take it any further because you might find yourself with a solution which is based on some new functionality which will then fail when you move that solution to older versions of the software.
How do I check compatibility
Microsoft Dynamics CRM uses a number of different products to make it work, Microsoft Dynamics has lots of different versions the infrastructure software has lots of versions, IE has versions, Outlook has version, everything has versions.
A popular question is usually can a customer’s server be used to Host an on premise CRM, what versions of the various software will they need to have.
Popular compatibility questions
- What version of software SQL Server, Windows Server, IIS, IE,etc, etc will work with Microsoft Dynamics CRM
- Does the new version of SQL Server 2012 work with Microsoft Dynamics CRM.
- When will new version of software be compatiable
- how long will IE 6 be supported (some customers really loved IE 6!)
Compatibility with different version is changing all the time and I have found the best place to check if a software version is compatible with your version of CRM is using the link below
Compatibility with Microsoft Dynamics CRM
It has the compatibility for each supported version of Microsoft Dynamics CRM
Compatibility with Microsoft Dynamics CRM 4.0
Compatibility with Microsoft Dynamics CRM 2011
Compatibility with Microsoft Dynamics CRM 2013
NO Microsoft Dynamics CRM 2015 yet
If you click on one of the links you get the details for that product. Not just types but versions, here is the CRM 2013 list. You see what version of CRM is compatiable with the software CRM installations use.
Microsoft Dynamics CRM 2013
The following products have been tested or are currently being tested for compatibility with Dynamics CRM 2013. The Minimum CRM version and CRM build number fields list the minimum Microsoft Dynamics CRM version that has been tested and that is compatible with the listed product.
|Product||Minimum CRM version||CRM build number||Status|
|.Net Framework 4.5.2||Update Rollup 2||220.127.116.11||Compatible|
|Active Directory Federation Services in Windows Server 2008 (AD FS 2.0)||RTM||18.104.22.1689||Compatible|
|Active Directory Federation Services in Windows Server 2008 R2||RTM||22.214.171.1249||Compatible|
|Active Directory Federation Services in Windows Server 2012||RTM||126.96.36.1999||Compatible|
|Active Directory Federation Services in Windows Server 2012 R2||RTM||188.8.131.529||Compatible|
|Azure virtual machines (support for Microsoft Azure virtual machines)||–||–||Not Compatible|
|CRM 2011 for Outlook Client||Update Rollup 12||5.0.9690.3236||Compatible|
|Exchange Server 2000||–||–||Not Compatible|
|Exchange Server 2003||–||–||Not Compatible|
|Exchange Server 2007 Standard||RTM||184.108.40.2069||Compatible|
|Exchange Server 2007 Enterprise||RTM||220.127.116.119||Compatible|
|Exchange Server 2010 Standard||RTM||18.104.22.1689||Compatible|
|Exchange Server 2010 Enterprise||RTM||22.214.171.1249||Compatible|
|Exchange Server 2013 Standard||Update Rollup 2||6.0.0002.0043||Compatible|
|Exchange Server 2013 Enterprise||Update Rollup 2||6.0.0002.0043||Compatible|
|Internet Explorer 8||RTM||126.96.36.1999||Compatible|
|Internet Explorer 9||RTM||188.8.131.529||Compatible|
|Internet Explorer 10||RTM||184.108.40.2069||Compatible|
|Internet Explorer 11||Update Rollup 2||6.0.0002.0043||Compatible|
|iOS7 Safari on iPad (web application)||Update Rollup 2||6.0.0002.0043||Compatible|
|iPad Air using Safari (web application)||Update Rollup 2||6.0.0002.0043||Compatible|
|iPad Air using CRM for Tablets||Update Rollup 2||6.0.0002.0043||Compatible|
|Microsoft SharePoint 2010 SP1 (all editions)||RTM||220.127.116.119||Compatible|
|Microsoft SharePoint Foundation 2013||RTM||18.104.22.1689||Not Compatible|
|Microsoft SharePoint 2013||RTM||22.214.171.1249||Compatible|
|Microsoft SQL Server 2000||–||–||Not compatible|
|Microsoft SQL Server 2005||–||–||Not compatible|
|Microsoft SQL Server 2008 Workgroup||–||–||Not compatible|
|Microsoft SQL Server 2008 Web||–||–||Not compatible|
|Microsoft SQL Server 2008 Compact (CRM server)||–||–||Not compatible|
|Microsoft SQL Server 2008 Express (CRM server)||–||–||Not compatible|
|Microsoft SQL Server 2008 Standard SP3 (x64)||RTM||126.96.36.1999||Compatible|
|Microsoft SQL Server 2008 Standard R2 SP2||RTM||188.8.131.529||Compatible|
|Microsoft SQL Server 2008 Enterprise SP3 (x64)||RTM||184.108.40.2069||Compatible|
|Microsoft SQL Server 2008 Enterprise R2 SP2||RTM||220.127.116.119||Compatible|
|Microsoft SQL Server 2008 Datacenter SP2 (x64)||RTM||18.104.22.1689||Compatible|
|Microsoft SQL Server 2008 Datacenter R2 SP2||RTM||22.214.171.1249||Compatible|
|Microsoft SQL Server 2008 Developer SP3 (x64)||RTM||126.96.36.1999||Compatible*|
|Microsoft SQL Server 2008 Developer R2 SP2||RTM||188.8.131.529||Compatible*|
|Microsoft SQL Server 2012 Enterprise SP1 (x64)||RTM||184.108.40.2069||Compatible|
|Microsoft SQL Server 2012 database engine||–||–||Not compatible|
|Microsoft SQL Server 2012 BI SP1 (x64)||RTM||220.127.116.119||Compatible|
|Microsoft SQL Server 2012 Standard SP1 (x64)||RTM||18.104.22.1689||Compatible|
|Office 2013 C2R (stand-alone)(Cached-Exchange Mode Only)||RTM||22.214.171.1249||Compatible|
|Office 2013 C2R (side-by-side with Office 2010)(Cached-Exchange Mode Only)||RTM||126.96.36.1999||Compatible|
|Office 2013 SP1 (Cached-Exchange Mode Only)||Update Rollup 2||6.0.0002.0043||Compatible|
|Office 2013 SP1 with CRM 2013 SP1 (Cached-Exchange Mode Only)||Service Pack 1||6.1.0000.0581||Compatible|
|Windows 8.1||Update Rollup 2||6.0.0002.0043||Compatible|
|Windows 8.1 w/ update KB2919355 (web client only)||Update Rollup 3||6.00.0003.0106||Compatible|
|Windows Server 2003||–||–||Not compatible|
|Windows Server 2008 Standard SP2 (x64)||RTM||188.8.131.529||Compatible|
|Windows Server 2008 Standard R2 SP1||RTM||184.108.40.2069||Compatible|
|Windows Server 2008 Enterprise SP2 (x64)||RTM||220.127.116.119||Compatible|
|Windows Server 2008 Enterprise R2 SP1||RTM||18.104.22.1689||Compatible|
|Windows Server 2008 Datacenter SP2 (x64)||RTM||22.214.171.1249||Compatible|
|Windows Server 2008 Datacenter R2 SP1||RTM||126.96.36.1999||Compatible|
|Windows Web Server 2008 Datacenter SP2 (x64)||RTM||188.8.131.529||Compatible|
|Windows Web Server 2008 Datacenter R2 SP1||RTM||184.108.40.2069||Compatible|
|Windows Server 2012 Foundation||–||–||Not compatible|
|Windows Server 2012 Essentials||–||–||Not compatible|
|Windows Server 2012 Datacenter||RTM||220.127.116.119||Compatible|
|Windows Server 2012 Standard||RTM||18.104.22.1689||Compatible|
|Windows Server 2012 R2 (CRM server)||Update Rollup 2||6.0.0002.0043||Compatible|
|Windows Small Business Server|
NOTES – Not supported
There is also an important little section at the bottom of the compatibility pages called notes. This has information about things which are not supported, once again I will use the CRM 2013 as an example
- 32-bit versions of Microsoft SQL Server 2008 and Microsoft SQL Server 2012 Reporting Services are not supported.
- Microsoft SQL Server 2008 Workgroup is not supported for running the Microsoft Dynamics CRM Reporting Extensions.
- Running a Microsoft SQL Server 2012 Reporting Services server in SharePoint mode is not supported with Microsoft Dynamics CRM.
- The CRM for Outlook client does not support Outlook configured in Online for tracking or synchronization (non-Cached Exchange mode)
Is CRM 4 compatible with Active Directory 2016?
The last time I used CRM 4 was 2010! I have no idea. You are going to have to try it yourself