debugsqlMinor
AlwaysOn High Availability doesn't work , can't activate it
Viewed 0 times
activatecanhighdoesnworkavailabilityalwayson
Problem
I am trying to activate the high availability
on my SQL server and getting below message:
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.
on my SQL server and getting below message:
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.
Solution
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://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver15
https://learn.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.
Please read the prerequisite before doing set-up of always on availability:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-ver15
https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver15
https://learn.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.
Context
StackExchange Database Administrators Q#260502, answer score: 8
Revisions (0)
No revisions yet.