Im trying to find out if Dynamics CRM 2011 is compatible with SQL Server 2017 running in 2008 R2 compatibility mode

(0) Share

Report

Posted on by Community Member

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

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

RE: Im trying to find out if Dynamics CRM 2011 is compatible with SQL Server 2017 running in 2008 R2 compatibility mode

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?
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: Im trying to find out if Dynamics CRM 2011 is compatible with SQL Server 2017 running in 2008 R2 compatibility mode

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.
Community Member on at

Like (0)

Report

RE: Im trying to find out if Dynamics CRM 2011 is compatible with SQL Server 2017 running in 2008 R2 compatibility mode

What about 2012?
David Jennaway 14,065 on at

Like (0)

Report

RE: Im trying to find out if Dynamics CRM 2011 is compatible with SQL Server 2017 running in 2008 R2 compatibility mode

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.