CRM 2016 and SQL 2016 Updates

(0) Share

Report

Posted on by Community Member

Hello All,

If we're deploying CRM 2016 with SQL 2016 Standard edition, my understanding is we need to be on SQL 2016 RTM CU2 to be in a supported state.

What is Microsoft's guidance with regards to subsequent CU's for SQL 2016? Are we supposed to stay on CU2 to run CRM 2016? If so we need to block installation of subsequent CU's that come down via Windows Update. That sounds messed-up to me!

Thanks,

*This post is locked for comments

All responses (6)

Answers (1)

Aric Levin - MVP 30,188 Moderator on at

Like (0)

Report

RE: CRM 2016 and SQL 2016 Updates

You should be able to update to a higher release then CU2. This is the minimal requirement for SQL 2016. Usually higher versions will be backwards compatible unless specifically specified.
Verified answer

Syed Ibrahim 6,257 on at

Like (0)

Report

RE: CRM 2016 and SQL 2016 Updates

More recent also can. All ours are cu 2. We hvnt updated to cu3. Always most recent will support. So no worries
Community Member on at

Like (0)

Report

RE: CRM 2016 and SQL 2016 Updates

Hi Syed,

Are these minimum or exact requirements?

For example would I be able to use SQL 2016 CU3? This is what I'm trying to find out.

If I'm using SQL 2016, is CU2 MANDATORY or is a more recent CU ok?

Thanks,

D.
Suggested answer

Syed Ibrahim 6,257 on at

Like (0)

Report

RE: CRM 2016 and SQL 2016 Updates

No need be any of the following versions can.

*Microsoft SQL Server 2016, Enterprise with Cumulative Update 2 (CU2)

*Microsoft SQL Server 2016, Standard with Cumulative Update 2 (CU2)

*Microsoft SQL Server 2016, Developer, with Cumulative Update 2 (CU2) (for non-production use only)

SQL Server 2014 Enterprise, 64-bit with SP2

SQL Server 2014 Business Intelligence, 64-bit with SP2

SQL Server 2014 Standard, 64-bit with SP2

SQL Server 2014 Developer, 64-bit with SP2 (for non-production use only)

Microsoft SQL Server 2012, Enterprise, 64-bit SP3

Microsoft SQL Server 2012, Business Intelligence, 64-bit SP3

Microsoft SQL Server 2012, Standard, 64-bit SP3

Microsoft SQL Server 2012, Developer, 64-bit SP3 (for non-production use only)

For more detail pls chk the below recommendations from ms

technet.microsoft.com/.../hh699671.aspx
Community Member on at

Like (0)

Report

RE: CRM 2016 and SQL 2016 Updates

Hi Syed, thanks for this link.

From the article:

We are now recommending proactive, ongoing install of Cumulative Updates. Read more on the ISM model in blogs.msdn.microsoft.com/.../announcing-updates-to-the-sql-server-incremental-servicing-model-ism.

...But for CRM 2016 we need to stay on SQL 2016 CU2?

Thanks,

D.
Suggested answer

Syed Ibrahim 6,257 on at

Like (0)

Report

RE: CRM 2016 and SQL 2016 Updates

Pls check the Microsoft comment in the below link.

connect.microsoft.com/.../allow-users-to-disable-auto-update-feature-in-sql-server-2016

Hope this helps