7

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.

14

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

|improve this answer|||||
8

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:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/windows-server-failover-clustering-wsfc-with-sql-server?view=sql-server-ver15

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.

|improve this answer|||||

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.