Share via

SQL license query

Ramit Sharma 0 Reputation points
2024-03-26T16:18:17.6833333+00:00

Query regarding Azure SQL production server licensing

Azure SQL Database
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,361 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marcin Policht 18,270 Reputation points MVP
    2024-03-26T16:23:32.7866667+00:00

    The primary licensing consideration in this context is the use of Azure Hybrid Benefits - more at

    https://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

  2. hossein jalilian 5,560 Reputation points
    2024-03-27T00:27:32.42+00:00

    Hello Ramit,

    Thanks for posting your question in the Microsoft Q&A forum.

    SQL Server CALs are not required for SQL Server 2022. Microsoft has transitioned to a core-based licensing model for SQL Server 2019 and later versions. With core-based licensing, you only need to purchase licenses based on the number of cores in your SQL Server VM, not the number of users accessing the server.

    Since you mentioned that your VM has dual cores, you'll need to purchase two SQL Server Standard licenses to cover the SQL Server installation on that VM.

    Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

    0 comments
  3. Olaf Helper 43,246 Reputation points
    2024-03-27T06:35:59.77+00:00

    I'd like to know how to procure and assign a SQL Standard license

    That's an "Edition Upgrade", easily done, see https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver16

    0 comments
  4. ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
    2024-03-30T14:48:46.44+00:00

    Hi Ramit Sharma,

    Welcome to Microsoft Q&A forum.

    As I understand, you have a question on SQL Server licensing.

    If it is related to SQL Server, SQL Server 2019 is offered in two main commercial editions to accommodate the unique feature, performance and price requirements of organizations and individuals:

    • Enterprise Edition is ideal for applications requiring mission critical in-memory performance, security and high availability.
    • Standard Edition delivers fully featured database capabilities for mid-tier applications and data marts.

    The editions are offered in a straightforward, tiered model that creates greater consistency across the product editions, features and licensing. Enterprise Edition includes all the capabilities available in SQL Server 2019.

    If the question is about SQL Server on Azure Virtual Machines (VMs), there are three license models for an Azure VM that's hosting SQL Server: pay-as-you-go, Azure Hybrid Benefit (AHB), and High Availability/Disaster Recovery (HA/DR). You can modify the license model of your SQL Server VM by using the Azure portal, the Azure CLI, or PowerShell.

    More details: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/licensing-model-azure-hybrid-benefit-ahb-change?view=azuresql&tabs=azure-portal

    Hope this helps. Let us know if you have more queries.

    Thanks

    0 comments