0

I am trying to enable the Always On Availability Groups feature of SQL Server 2012 Enterprise Edition on Windows Server Standard Edition 2012, but it says the feature requires X64 Enterprise Edition of SQL Server 2012 or Windows 2008 Enterprise edition or above.

I already have Windows Standard 2012 and SQL Server 2012 Enterprise Edition, why can't I enable this feature?

  • 3
    Can you provide the results from SELECT @@VERSION and have you already put the Windows machines in a WSFC? – Nic Mar 24 '17 at 19:30
  • I have already installed WFCS with two nodes, fileshare as witness and installed sql enterprise edition on to it. Following is the version info Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86) Dec 28 2012 19:06:41 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing on Windows NT 6.2 <X64> (Build 9200: ) (WOW64) (Hypervisor) – Sql_Crazy Mar 25 '17 at 10:48
1

Per the information you provided from SELECT @@VERSION you are running the x86 version of SQL Server 2012. It would appear that the OS and SQL Server architecture must match in order for Availability Groups to function.

This means that you would either need to change your SQL Server installation to the x64, or go to a prior version of Windows (2008) and install the x86 version of that.

My recommendation would be to adjust your existing install and make it x64. This provides many enhancements such as not needing to mess with things like PAE and AWE when using more than 4GB of memory.

1

AlwaysOn Availability Groups require Windows cluster services. With 2008r2 and before, those are only available in the enterprise and datacenter editions of the Windows operating system. Check these for more details: https://technet.microsoft.com/en-us/library/cc771404(v=ws.11).aspx and https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability The second article talks more to SQL 2016, though I've used it as an aide when working with SQL 2014. In addition, Brent Ozar's site is a valuable resource. Check this out as well: https://www.brentozar.com/sql/sql-server-alwayson-availability-groups/

  • 1
    This is innacurate. Windows enterprise is NOT required, except when running 2008 or earlier. Windows Server Failover Clustering is supported in Standard Edition and higher from the 2012 release. A worksheet for feature supportability for R2 can be found at microsoft.com/en-us/download/confirmation.aspx?id=41703 – Nic Mar 27 '17 at 13:36
  • @Nic thank you for catching that - I've only ever used the enterprise edition of Windows. Answer updated. – S M Mar 28 '17 at 15:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.