Activate MS SQL

Hypothetical question around activating MS SQL

If you have a server with 10 physical cores (not virtualised) and you buy 2x 2 core license packs for MS SQL 2014- when you install it will it fail as it doesn't have enough licenses vs the actual cores or will it run without issue?

I'm aware of the licensing laws etc, I just want to know if SQL stops working or won't install etc without the correct licensing
LVL 12
Who is Participating?
Dustin SaundersDirector of OperationsCommented:
If I recall, you shouldn't have any issue but you would see the sql service only using the cores it's licensed for.  The same is true for sql express, you would see it only able to use the 1 socket.
yo_beeDirector of Information TechnologyCommented:
I have never seen licensing affect functionality.  When you have a licensed copy of MS software you are the honor system and if audited is where things get ugly.

I maybe incorrect, but I do not think that it will cause any issues with running the system, but as a business practice it probably best that you true up with the correct license model.  You maybe better off with per seats vs per core model.
Vitor MontalvãoMSSQL Senior EngineerCommented:
It should install and work but if you don't want to have problems with Microsoft (they should run an audit every year or so), remove the extra CPUs from the machine so it will match the number of licensed cores.
DBAduck - Ben MillerPrincipal ConsultantCommented:
To answer your question, the license is not installed with SQL setup.  Licensing is an accounting to Microsoft. It will install fine.
DLeaverAuthor Commented:
Thanks for your answers
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.