?
Solved

Windows 2012 R2 server + SQL server 2014

Posted on 2014-11-13
15
Medium Priority
?
358 Views
Last Modified: 2014-11-17
Dear all,

right now try to use new windows server + SQL server for an application.

MS here only sales Windows 2012 R2 and SQL server 2014 license, as we are currently running Windows 2008 R2 enterprise to build a 2 x nodes clusters and install SQL server 2008 R2 standard edition on top of 2 x nodes Windows 2008 R2 cluster, we are not sure if Windows 2012 R2 standard edition to form a 2 x nodes clusters and the install SQL server 2014 standard edition on top of this 2 x nodes Windows 2012 R2 cluster.

Please share the possibility of it !

so if we have 3 x nodes for cluster then we need to use Windows 2012 R2 Enterprise edition and SQL server 2014 enterprise edition ?
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40439954
so if we have 3 x nodes for cluster then we need to use Windows 2012 R2 Enterprise edition and SQL server 2014 enterprise edition ?
Yes for SQL Server 2014 EE and no for Windows Server 2012R2 EE.
SQL Server 2014 Standard Edition supports until 2 cluster nodes. For Windows Server 2012R2 there's no limitation for the number of a cluster nodes in any edition.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40441813
hey man, thsnk for that, are you posting adv in somewhere as I seems recogonise you in other internet post.

"For Windows Server 2012R2 there's no limitation for the number of a cluster nodes in any edition. "

so Windows server 2012 R2 standard edition can do a 2x nodes cluster and than SQL server 2014/2008 R2/2012 standard edition can install on top of it and form a 2 x nodes cluster?

if so, who will buy Windows server 2012 R2 EE then ? no need any more, any comparsion charT?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40442054
There's no Enterprise Edition for Windows Server 2012. Microsoft now offer Standard and Datacenter editions.
You can read more about it here.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40442144
"There's no Enterprise Edition for Windows Server 2012. Microsoft now offer Standard and Datacenter editions."

yes!

standard eidtion seems only different from DC edition in terms of virtual machine! and the rest of the feature is the same, is that right?

and SQL server 2014 standard edition in this case has the limit, only 2 nodes clusters, agree?
0
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 40442160
Yes, I agree.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40442255
so do you think it is a vaild approach to build a 2 x nodes cluster by Windows 2012 R2 standard edition and then install SQL server 2014 standard edition on top of it to form a 2 x nodes SQL server 2014 clustered server?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40442260
Yes, it's valid.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40442270
tks.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40446898
one thing, TDE encryption rise on SQL server 2008 R2 enterprise edition, right ? any real life comparsion between the performance of TDE on SQL server 2008 R2 enterprise and SQL 2012 enterprise edition?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40446908
Yes, it's only available on Enterprise Edition but I can't tell you if there's differences in performance between SQL Server versions. I don't even know if someone did that comparison already.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40446963
so do you think it is a vaild approach to build a 2 x nodes cluster by Windows 2012 R2 standard edition and then install SQL server 2014 ENTERPRISE EDITION on top of it to form a 2 x nodes SQL server 2014 clustered server?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40446986
If you need TDE or another feature only available in Enterprise Edition, then yes. Otherwise MSSQL 2014 Standard Edition will fit your needs just fine.
Both the OS needs to be  Windows 2012 R2 standard edition for you can create the cluster.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40447143
"If you need TDE or another feature only available in Enterprise Edition, then yes"

yes, that's the reason ! we need TDE !

TDE has to encrypt the whole database instead of table by table, right?

" Otherwise MSSQL 2014 Standard Edition will fit your needs just fine."

yes !

"Both the OS needs to be  Windows 2012 R2 standard edition for you can create the cluster."

you mean both edition of SQL server (Standard and enterprise), right ? so Windows 2012 R2 standard + SQL server 2014 enterprise edition, right?
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40447150
Yes to all questions :)
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question