asked on

Installing sql server always on on 2 vms inside an Hyper-V Cluster

I have a 3 nodes HyperV HA Cluster, with Starwind storage.
One of the main vm's is a SQL Server 2016, which i would like to have working in a "Always On Availability Group"
I thought it would be a matter of just adding a new SQL vm in another node and set it as replica, but while trying to install, i see SQL Server needs it's own cluster to work this way.
How can i install it in this scenario?

Thanks
Jaime

lcohan

SQL Server needs it's own cluster to work this way

Yo will need first to build a WFCS Cluster as Always On Availability Group depends on Windows Clustering. Please read and fulfill all prerequisites as described here first:

Ensure that each computer is a node in a Windows Server Failover Clustering (WSFC) with SQL Server

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

GreatSolutions

ASKER

Thanks, that's the doc that got me rethinking the issue in the first place.
I'll need to build a Cluster inside my cluster, in order to implement.

Thanks

yo_bee

Also keep in mind your windows licensing. I have seen companies get slammed with a big amount of money from Microsoft because they improperly deploy SQL.
SQL is on of Microsoft's most expensive applications and if you are blind to their entitlement of use it can really bite you in the ass.

GreatSolutions

ASKER

Thanks, i know about the prohibitive cost of SQL licenses, in this case i went for per CORE licensing, i know i "loose" cores for the replica as well...

yo_bee

I recall if you want to run in a HA environment you need to have it licensed for the total cores on the Hypervisor in your cluster. With MS the licensing models change like the weather.

GreatSolutions

ASKER

Well, in my VM when i try to add the HyperV role, i get an error: HyperV cannot be installed, the processor does not have required virtualization capabilities. What am i doing wrong?

ASKER CERTIFIED SOLUTION

GreatSolutions

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial