I am trying to activate the high availability on my SQL server and getting below message:

enter image description here

SQL server version: Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Express Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 (Build 9600: ) (Hypervisor)

Operating System: windows server 2012.

Appreciate any help.


2 Answers 2


You need Enterprise edition for fully functional Always ON AG and a minimum Standard edition to use the basic Always On AG. Express edition of SQL Server does not supports Availability Groups


If you read the message above in your screenshot, its very clear that it requires enterprise edition in order to enable always on availability group, even for basic AG you need to have standard edition of Sql server. This also requires WSFC hotfix to be installed on the operating system. It doesn't work on SQL server express edition.

Please read the prerequisite before doing set-up of always on availability:




Once you meet the prerequisite, please follow step by step instructions and coomplete the setup. you may refer this article written by Mr. Brent Ozar.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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