how to Run SQL server Standard edition on Docker with license key

Question

I went to run SQL Server standard edition on docker-compose. I have applied the license on the compose environment variable but in query, it shows that LicenceType is disabled.

SELECT SERVERPROPERTY('LicenseType') as Licensetype, 
   SERVERPROPERTY('NumLicenses') as LicenseNumber,
   SERVERPROPERTY('productversion') as Productverion, 
   SERVERPROPERTY ('productlevel')as ProductLevel, 
   SERVERPROPERTY ('edition') as SQLEdition,@@VERSION as SQLversion

version: '3.8'

services:
  mssqlserver:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: mssql_server
    restart: unless-stopped
    ports:
      - "hostport:1433"
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_PID=Standard
      - MSSQL_SA_PASSWORD=pass
      - MSSQL_LICENSE=license_key
    volumes:
      - hostpath:/var/opt/mssql/data
      - hostpath:/var/opt/mssql/log
      - hostpath:/var/opt/mssql/backup
      
    networks:
      - mssql_network


networks:
  mssql_network:
    driver: bridge

Answer 1

Yes, that is expected. From the documentation of serverproperty:

Answer 2

Hi @Easy Payment System - EPS,

For question regarding pricing / licensing please contact a Microsoft sales partner or licensing expert.

Please call 1-800-426-9400, 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. People there will help you more effectively.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.