SQL Standard on Windows VM in HYPER-V Cluster

Question

Hello All

I've question about licensing.
I have VM Windows Server 2019 with SQL Standard installation. This VM is working in Hyper-V Cluster (2 nodes).
When first node will be destroyed VM will be moved to second node.
My question is when I migrate whole VM from one node to another one do I need to buy Software Assurance for SQL Standard on this server?

Answer 1

Hi @Damian Feliszewski ,

It seems your question is more about license. I suggest that you can consult professionals in this area. For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations. For Volume Licensing Service Support, please use the https://learn.microsoft.com/en-us/licensing/contact-us to contact information for your country.

Answer 2

Yes, but I don't want to create HA on SQL, only on HYPER-V. So when first node will be destroyed whole Windows VM will be moved to second node. VM will be moved to another node, not only database I also need to by SA for SQL Standard?

Answer 3

You need separate licences.

Also is good to know that in Standard edition you can use Basic Availability Groups and not Always On Availability Groups.

You can find differences below:
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-ver15