Home icon

Containerize SQL Server on AWS to reduce licensing costs and simplify operations

Microsoft Workloads on AWS Blog



This article demonstrates how to containerize Microsoft SQL Server on AWS using Linux containers on Amazon EKS, reducing licensing costs while maintaining performance and compatibility.

  • Eliminate Windows Server licensing by running SQL Server on Linux container hosts
  • License only virtual cores allocated to containers instead of all physical cores, reducing SQL Server licensing by up to 75%
  • Combined licensing and compute savings of 40-60% under the Bring Your Own License model
  • Deploy SQL Server 2022 as a StatefulSet on EKS with persistent EBS storage for data, logs, and backups
  • Secure credentials using AWS Secrets Manager with IAM Roles for Service Accounts (IRSA)
  • Expose SQL Server via Network Load Balancer on port 1433 for external connectivity
  • Implement production best practices including storage separation, TLS encryption, non-root execution, and network policies
  • Step-by-step walkthrough covers cluster creation, driver installation, Helm deployment, and connection verification

Containerizing SQL Server on EKS delivers significant cost savings through licensing optimization while providing operational benefits like simplified management, security hardening, and scalability through Kubernetes orchestration.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jun 14
2024
Containerize SQL Server workloads with Amazon EKS and DxOperator for Kubernetes
Jan 3
2024
Migrate SQL Server databases to AWS with minimal downtime using AWS Migration Hub Orchestrator
Aug 2
2024
New research shows AWS is the cloud provider of choice for SQL Server
Oct 29
2026
Amazon RDS for Oracle and SQL Server now support storage autoscaling on additional storage volumes

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.