marrowyung
asked on
Windows 2012 R2 server + SQL server 2014
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 ?
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 ?
Last Comment
ASKER
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?
"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?
ASKER
There's no Enterprise Edition for Windows Server 2012. Microsoft now offer Standard and Datacenter editions.
You can read more about it here.
You can read more about it here.
ASKER
"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?
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?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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?
Yes, it's valid.
ASKER
tks.
ASKER
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?
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.
ASKER
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?
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.
Both the OS needs to be Windows 2012 R2 standard edition for you can create the cluster.
ASKER
"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?
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?
Yes to all questions :)
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.