Deploy ec2 AMI with sql 2022 web edition - amazon linux based

0

we want to deploy an ec2 AMI with mssql 2022 web edition on Amazon Linux os, all I can find in the community AMIs are Ubuntu / RedHat based, while SQL 2019 web edition exists with amazing Linux.

Does SQL 2022 web on Linux exist only with those 2 distributions? I'm not talking about 3rd party support style..

thanks!

asked 22 days ago37 views
1 Answer
0

Based on the available information, it appears that SQL Server 2022 Web Edition on Linux is not officially supported or available on Amazon Linux. Microsoft primarily supports SQL Server on Linux for Red Hat Enterprise Linux (RHEL) and Ubuntu distributions.

While SQL Server 2019 Web Edition was available on Amazon Linux, the same cannot be confirmed for SQL Server 2022 Web Edition. The official support and availability seem to be limited to RHEL and Ubuntu distributions for SQL Server 2022.

It's important to note that Microsoft's documentation and official support channels typically refer to RHEL or Ubuntu for Linux installations of SQL Server. This suggests that these are the primary Linux distributions supported for SQL Server 2022, including the Web Edition.

If you specifically need to run SQL Server 2022 Web Edition on Linux, you may need to consider using either RHEL or Ubuntu as the base operating system for your EC2 instance. These distributions are known to have official support and are more likely to have readily available AMIs in the AWS Marketplace or community AMIs.

Alternatively, if using Amazon Linux is a strict requirement for your use case, you might need to explore other options such as:

  1. Using SQL Server 2019 Web Edition on Amazon Linux if that meets your needs.
  2. Considering Windows-based EC2 instances for SQL Server 2022 Web Edition.
  3. Exploring Amazon RDS for SQL Server if a managed database service is suitable for your requirements.

Remember that using officially supported configurations ensures better compatibility, performance, and support from both Microsoft and AWS.
Sources
Microsoft FAQ – AWS
Evaluate SQL Server on Linux - AWS Prescriptive Guidance
SQL Server Developer Edition on Amazon Linux 2023 AMI | AWS re:Post
Find an AMI that meets the requirements for your EC2 instance - Amazon Elastic Compute Cloud

profile picture
answered 22 days ago
profile picture
EXPERT
reviewed 21 days ago
  • If instead of Amazon Linux, one wanted to use the supported Ubuntu image w/ SQL Server Web, where can you find an AMI? I'm not able to locate one for Ubuntu either.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions