Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Launch EC2 instance Ubuntu Server 22 w/ SQL Server 2022 Web. Where to find AMI?

0

My main goal is to launch a linux instance with SQL Server Web.

I can find AMIs for Ubuntu 22 w/o SQL Server or with SQL Server standard. I've also found Redhat and Windows distros, but I'd like to stick to ubuntu. I want to use an AMI to have the AWS managed liscense for SQL Server.

The AWS docs list running SQL Server web on linux on a r5.2xlarge instance. I can't find an AMI for it though. https://docs.aws.amazon.com/prescriptive-guidance/latest/optimize-costs-microsoft-workloads/sql-server-linux.html

Is the solution recomended in the docs not possible or am I missing something.

I'm open to other editions of Ubuntu or SQL server if 2022 AMIs aren't available. I'd rather go with a more current version if possible though.

Bonus: Is there an Ubuntu AMI with SQL Server Developer preinstalled that I can use for development?

Topics
ComputeDatabase
Tags
LinuxMicrosoft SQL ServerAmazon EC2
Language
English
asked 10 months ago297 views
1 Answer
1

Based on the available information, it appears that finding an Ubuntu Server 22.04 AMI with SQL Server 2022 Web Edition pre-installed is not straightforward. Here's what we can conclude:

  1. SQL Server 2022 is indeed available on AWS, including for Linux-based instances. However, the availability of specific combinations of operating systems and SQL Server editions may be limited.

  2. While you can find AMIs for Ubuntu 22.04 without SQL Server or with SQL Server Standard edition, there doesn't seem to be a readily available AMI that combines Ubuntu 22.04 with SQL Server 2022 Web edition.

  3. The AWS documentation you referenced does mention running SQL Server Web on Linux on an r5.2xlarge instance, but this doesn't necessarily mean there's a pre-built AMI for this configuration.

Given these constraints, you have a few options:

  1. Use a different Linux distribution: You might find an AMI with SQL Server 2022 Web edition pre-installed on a different Linux distribution, such as Red Hat Enterprise Linux.

  2. Use a different SQL Server edition: If Ubuntu is a must, you could use an AMI with SQL Server Standard edition instead of Web edition.

  3. Manual installation: You could start with a base Ubuntu 22.04 AMI and manually install SQL Server 2022 Web edition. This would require more setup but would give you the exact configuration you want.

  4. Contact AWS Support: They might be able to provide more information about the availability of specific AMI configurations or guide you on how to achieve your desired setup.

Regarding your bonus question about an Ubuntu AMI with SQL Server Developer edition pre-installed for development purposes, there doesn't appear to be a pre-built AMI for this configuration either. However, you can download the free SQL Server 2022 Developer edition from Microsoft's website and install it on an EC2 instance running Ubuntu for your non-production workloads.

Remember that AMI availability can vary by region and can change over time. It's always worth checking the EC2 console directly for the most up-to-date options in your specific region.
Sources
Find a SQL Server license-included AMI - Microsoft SQL Server on Amazon EC2
Microsoft FAQ – AWS
Community | Setting Up a VM as Remote Development Machine

answered 10 months ago
AWS
EXPERT
reviewed 10 months ago

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.

Relevant content