EC2 Instance with SQL Server Web Edition

Question

I would like to launch an EC2 instance (t3a.medium) on Windows Operating System with SQL Server Web. However, the options available were only with SQL Server Standard and Enterprise Edition. I have searched the marketplace but the packages available there does not come with t3a.medium. How can I solve this?

Rob_H EXPERT
a year ago
Have you tried launching and stopping the instance to see if you can change from a t3a.xlarge to t3a.medium after launch?

Answer

Emily, thank you for this question. To answer your question, **yes, you can run SQL Server Web on a t3a.medium instance**.

It is a little unclear in the Elastic Compute Cloud (EC2) console on how to find the `t3a.medium` instance type. I apologize for that. Let me explain how you can accomplish your task!

1. Log into the AWS Console and head over to the [EC2 service](https://us-east-1.console.aws.amazon.com/ec2/home). Please note my link sends you to the us-east-1 Region, so remember to select the correct Region you are need to launch this instance in.
2. Go to `Launch instance` in the center middle of your screen. This is an orange rectangle button.
3. Select Windows in Quickstart and click on the AMIs list.
4. Type in the word `web`. As of today's date, you will notice there are two options for Windows Server with SQL Server Web, 2019 and 2022. Select the one you would like.
5. Scroll down to instance type and click on `Compare instance types`.
6. At the top where it says `Filter instance types` type in `t3a` and select `t3a.medium` or whatever other instance type you would like.
7. Scroll down to the bottom and click `Select instance type`.
8. You will now notice you have your Windows Server with SQL Server Web, on a t3a.medium instance!

If you need any more help, feel free to comment on this thread.

EC2 Instance with SQL Server Web Edition

Relevant content