we are looking to upgrade our existing SQL 2008 R2 instance and would rather move to 2017 rather than SQL 2012 if possible. Im trying to find out if Dynamics CRM 2011 is compatible with SQL Server 2017 running in 2008 R2 compatibility mode.
I've had a look at the 'Compatibility with Microsoft Dynamics CRM 2011' and the most recent version of SQL it contains is 2014. can someone help this ?
*This post is locked for comments
hi,
we do have one further question.
we currently have an instance of Dynamics CRM 2011 underpinned with a SQL Server 2008 R2 database.
The extended support end dates for the different components are as follows:
Platform End of Extended Support
SQL Server 2008 R2 July 2019
SQL Server 2012 SP1 July 2015 (SP1 end of support)
CRM 2011 July 2021
I’m now struggling to see what we can do (if we need to do anything) to remain supported.
I can see no benefit for us to upgrade from SQL 2008 R2 to SQL 2012 SP1 as this went out of support before SQL 2008 R2 (CRM compatibility information I have been able to find states that CRM 2011 is compatible with SQL Server 2012 up to SP1 and not beyond. SP1 support end date is July 2015.
My question now is can I assume that as CRM 2011 is supported until July 2021, any compatible SQL instance used will also be supported by default and the individual SQL end of support date is ignored?
If this is not the case, what options do we have?
Hello,
Here is the list of supported software - support.microsoft.com/.../compatibility-with-microsoft-dynamics-crm-2011
SQL Server 2012 seems to be supported based on the provided information.
I believe the best that you can do - just try to install it and you will get an answer.
What about 2012?
It's not supported to run CRM 2011 with SQL 2017. Theoretically it may well work, but it won't be supported as Microsoft haven't fully tested that scenario. You could probably get it to work if you upgrade SQL and Reporting Services on an existing CRM , but if you try a new CRM installation, it probably won't recognise SQL 2017. Normally the main issue is with the Reporting Services version, rather than the database engine.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
