Microsoft SQL Server licensing in container deployments

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 5 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Microsoft SQL Server Licensing in Container Deployments

    The Software Asset Management publisher pack for Microsoft provides guidance on licensing Microsoft SQL Server products deployed in Docker containers, applicable in both on-premise and cloud environments. Containers allow consistent application deployment across various computing environments, simplifying operational processes and enabling multiple isolated applications on a single OS.

    Show full answer Show less

    Key Features

    • The integration of Software Asset Management with ServiceNow® Discovery identifies Docker containers, Kubernetes clusters, the OS of physical servers, SQL Server versions, and the number of virtual processor cores assigned to each container.
    • Creation of software installation records for each discovered container to track and optimize license compliance.
    • Access to the Licensable Software Products Deployed on Containers report for enhanced visibility into SQL Server deployments across environments.

    Supported Licensing Models

    The following licensing models are supported for SQL Server products in container deployments:

    • Per Core: License each container as a standalone device, based on the number of vCPUs, with a minimum of four core licenses per container.
    • Server/CAL: Requires a server license for each container, alongside user or device CAL licenses for access to the physical server. Options include licensing individual installations or all installations on a server.

    Key Outcomes

    Using the Software Asset Management application, customers can effectively manage their SQL Server licensing in containerized environments, ensuring compliance and optimizing resource allocation. The tools and reports available provide comprehensive visibility and control over software deployments, enhancing overall asset management strategies.

    The Software Asset Management publisher pack for Microsoft supports licensing rules for Microsoft SQL Server products that are deployed across both on-premise and cloud environments using Docker containers.

    Containers are executable software packages that bundle all the code and dependencies that are required for deploying and running a specific application. With a container, you can deploy and run the same application uniformly across any computing environment, such as a desktop computer or the cloud, without having to reconfigure the application. Each container also virtualizes an operating system (OS) so that you can quickly and easily deploy multiple isolated applications within the same computing environment.

    The Software Asset Management application works in conjunction with the ServiceNow® Discovery application to identify the following information in both on-premise and cloud environments:
    • The Docker containers through which your Microsoft SQL Server products are deployed.
    • The corresponding Kubernetes clusters that enable each container to run.
    • The OS of the underlying physical server that the container is running on.
    • The Microsoft SQL Server version and edition that is deployed through each container.
    • The number of virtual processor cores that are assigned to each container.

    The Software Asset Management application uses the resulting data to create corresponding software installation records for each of your discovered containers. You can then reconcile these container-based software installations to track and optimize the license compliance of the Microsoft SQL Server products that are deployed through each container.

    For more visibility into the Microsoft SQL Server products that are deployed through your Docker containers, view the Licensable Software Products Deployed on Containers report.

    For more information on Docker discovery, see Docker virtualization. For more information on Kubernetes discovery, see Kubernetes discovery.

    Supported licensing models

    The Microsoft publisher pack supports the following licensing models for Microsoft SQL Server products that are deployed through containers:
    Note:
    For more information on each licensing model, refer to Supported Microsoft license types.
    Table 1. Supported Microsoft SQL Server licensing models in container deployments
    Licensing Model Description
    Per core You must license each container as a standalone device. Licensing is based on the number of virtual CPUs (vCPUs) that are discovered on each container, with a minimum of four per core licenses per container.
    Server/CAL

    You must license each container using a server (per instance or per server) license. You must also license each user or device that is accessing the underlying physical server running these containers using a user or device CAL license.

    Server licenses enable you to license container-based software installations on your physical servers. To license only a certain number of installations on a physical server, use a server (per instance) license. To license all installations on a physical server, use a server (per server) license.

    CAL licenses are client access licenses that grant a set number of users or devices access to the underlying physical server on which your containers are running.
    • To grant a set number of users access to a physical server, regardless of how many devices those users are accessing the server through, use a user CAL license.
    • To grant a set number of devices access to a physical server, regardless of how many users are accessing the server through those devices, use a device CAL license.