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

GreatSolutions
GreatSolutions used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
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

Author

Commented:
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_beeDirector of Information Technology

Commented:
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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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_beeDirector of Information Technology

Commented:
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.

Author

Commented:
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?
Commented:
Never mind found a solution

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial