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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.