January 10, 2017 at 7:30 am
Hi Friends,
We have CRM Dynamics(2015) and CRM NAV(2015),they both are on-prem versions, which runs off the SQL Server 2012 now.
We are planning to build DW solution and would like to update our SQL Server 2012 SE to SQL Server 2016 EE so we can leverage the use of POWER BI on-prem and DATAZEN as well. I do have few basic questions related to that since kind of newbie to CRM and administration side of SQL Server.
1. Is it possible just to update the SQL Server without updating MS Dynamics to 2016 version.
2. I know SQL Server 2016 EE comes with clustering capabilities, but what happens if server machine fails ( Hardware failure), may be I am trying to ask how to install 2016 on server on-premise so that we can avoid H/W and N/W failure?
3. Since we have 2012 SE licence version with 4 core is it different pricing for 2016 EE?
Thanks in advance for you help.
Learner44
January 10, 2017 at 12:38 pm
1. Is it possible just to update the SQL Server without updating MS Dynamics to 2016 version.
2. I know SQL Server 2016 EE comes with clustering capabilities, but what happens if server machine fails ( Hardware failure), may be I am trying to ask how to install 2016 on server on-premise so that we can avoid H/W and N/W failure?
3. Since we have 2012 SE licence version with 4 core is it different pricing for 2016 EE?
1. doesnt appear that SQL 2016 is certified with Dynamics CRM 2015, 2014 is supported. https://support.microsoft.com/en-ca/kb/3018360
2. You can use either Fail-over Clustering or availability groups for HA. a two node cluster is also possible with standard. https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx#High_availability
3. As for pricing, it would be the best to talk to your licensing provider, but as an example, 2016 Standard is $3717 per 2xCores and 2016 Enterprise is $14256 per 2xCores https://www.microsoft.com/en-us/sql-server/sql-server-2016-pricing
January 12, 2017 at 10:01 am
Note if you want to build a cluster, you won't likely be able to upgrade an instance in place. The install is different. You'll need to install SQL Server as a clustered installation.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply