Avatar of Darrin Moore
Darrin Moore
 asked on

How to determine what type of SQL Server license is currently being used?

We need to upgrade our SQL Server 2014 Standard to SQL Server 2017 Standard. We would like to determine what type of license is currently being applied  (how many cores? how many users? etc). Is this possible?

Microsoft SQL Server

Avatar of undefined
Last Comment
Darrin Moore

8/22/2022 - Mon
Lee W, MVP

I believe this is an administrative thing; SQL Server does not track this information by itself.  Look at what you purchased when you purchased it.

And since licensing does change, I might suggest it doesn't matter what you DID pay for it.  Look at what you need now; you'll need all new CALs anyway.
Darrin Moore

Hi Lee,

Thank you for responding. I was unsure how to classify the question. Should i reclassify and resubmit? There are completely different employees here from when the SQL server was installed previously so tracking down the PO is proving to be a challenge.
Lee W, MVP

Again, it doesn't really matter.  You're upgrading.  There is no special pricing for upgrades.  If you had software assurance, you'd have to have renewed it at most 2 years ago.  But you need all new licenses.  Look at the environment now, look at the licensing options NOW, and purchased based on today. What you had yesterday really doesn't matter.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Andrei Fomitchev


Microsoft SQL Server 2019 (RTM-CU10) (KB5001090) - 15.0.4123.1 (X64)   Mar 22 2021 18:10:24   Copyright (C) 2019 Microsoft Corporation  Developer Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 19042: ) (Hypervisor)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Darrin Moore

 Thank you, experts!