Share via

How to update the activation of SQL Server?

Haitham Al-Haj 0 Reputation points
2024-06-19T14:05:36.9733333+00:00

Dear All,

We have an open value agreement and recently we have added an extra SQL license to the agreement. First, we purchased a license for 4 cores then we added 4 cores.

Now, how can we use these new extra SQL Server licenses on the existing SQL Server environment because we are using SQL Server on VM and we have increased the number of cores?

  1. Is there a new key with an updated number of cores?
  2. Is there a way to modify the existing license or add to it?
  3. when we installed it in the first time, there was no product key and they only downloaded the software?, so is there a new key and how they can use it or add it to existing SQL Server?
  4. Please explain more about how they can move or use the licenses such as 4 cores for one server and 4 cores for another server since each license is per 2 cores. Is there an activation modification or new key each time?
  5. how do we make sure that the SQL server is licensed or not with how many cores license is using?

Please reply to each point and explain.

Thanks & Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,171 questions
Windows Licensing
Windows Licensing
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Licensing: Rules, regulations, and restrictions that define how software can be used and distributed.
54 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,746 Reputation points
    2024-06-19T17:14:44.8166667+00:00

    how can we use these new extra SQL Server licenses on the existing SQL Server environment

    You have SQL Server licenses only on "paper", there is nothing to activate nor to add licenses somewhere.

    Just take care you have the right type/ammount of licenses .. on "paper"-

  2. LucyChenMSFT-4874 2,820 Reputation points
    2024-06-20T06:02:10.1466667+00:00

    Hii @Haitham Al-Haj ,

    Thank you for reaching out and welcome to Microsoft Q&A!

    then how does Microsoft check if we have a valid key/activation for the SQL Server? or the number of core licenses we have is the same as the agreement?

    Please refer to SERVERPROPERTY (Transact-SQL). You have SQL Server licenses only on paper, but nowhere in the system; you have to take care on licensing on your own.

    In addition, you can call 1-800-426-9400 for detailed information about the license issue, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web.

    Is there a new key with an updated number of cores?

    I am not sure of how to change the key on same edition. You can do Edition Upgrade, which allows you to enter a new Product Key.

    https://www.mssqltips.com/sqlservertip/6686/edition-upgrade-and-downgrade-in-sql-server/

    when we installed it in the first time, there was no product key and they only downloaded the software?, so is there a new key and how they can use it or add it to existing SQL Server?

    What's the meaning of this issue? When you install a new SQL Server, you need to enter the new product key and click Next to continue the install, right?

    Please explain more about how they can move or use the licenses such as 4 cores for one server and 4 cores for another server since each license is per 2 cores. Is there an activation modification or new key each time?

    Maybe you need this? Hope it can help you well!

    how do we make sure that the SQL server is licensed or not with how many cores license is using?

    You can run

    SELECT @@VERSION

    If it returns "Standard Edition", that means it's licensed. SQL Server don't store any further license information; you have the license only on paper.

    You can refer Microsoft Licensing Reference Guide to get more detailed information!

    Feel free to share your issue here if you have any confusions.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications