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.
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
2024
2024
2024
2026
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.