SecureAnyCloud
Deployment guide

SQL Server 2022

Overview

SQL Server 2022 is the enterprise relational database platform for mission-critical workloads, analytics and high availability. This AWS Marketplace listing is a single product that ships five Microsoft SQL Server 2022 delivery options, all on Ubuntu 22.04 LTS. You choose the edition that matches your workload and licensing when you launch, and each edition has its own deployment guide.

Every edition is installed from the official Microsoft APT repository, ships with mssql-tools18 and sqlcmd, and runs on port 1433. Each stores its data on a dedicated, independently resizable EBS volume at /var/opt/mssql and generates unique per-instance credentials on first boot. The images are headless, so you administer SQL Server over SSH with sqlcmd or any compatible client. The SSH login user is ubuntu on every edition.

Use the table in the next section to choose your edition and open its guide.

Select Your Edition

1 Enterprise Paid (evaluation until a product key is applied) Mission-critical production at scale None beyond OS/hardware Open guide

2 Standard Paid (evaluation until a product key is applied) Mid-tier production workloads 24 cores, 128 GB buffer pool Open guide

3 Web Paid, low-cost (evaluation until a product key is applied) Public web-facing applications and hosting 16 cores, 64 GB; web-facing use only Open guide

4 Express Free Small databases, prototypes, learning 10 GB max database, ~1.4 GB buffer pool Open guide

5 Developer Free (development and test use only) Dev/test with the full Enterprise feature set Not licensed for production Open guide

  • SQL Server 2022 Enterprise: the complete feature set for mission-critical scale, including multi-replica Always On Availability Groups, in-memory OLTP, columnstore indexes and TDE.
  • SQL Server 2022 Standard: the core relational engine for mid-tier production, within the 24-core / 128 GB envelope.
  • SQL Server 2022 Web: the low-cost edition for public web-facing applications and hosting.
  • SQL Server 2022 Express: the free entry-level edition for small databases (10 GB max).
  • SQL Server 2022 Developer: the full Enterprise feature set, free for development and test use only.

Which Edition Should I Choose?

Paid editions for production. Enterprise unlocks the complete feature set with no edition limits beyond your hardware, including multi-replica Always On, in-memory OLTP, columnstore and TDE, for mission-critical scale. Standard delivers the core engine for mid-tier production. It is capped at 24 cores and 128 GB of buffer-pool memory, with basic single-secondary Always On. Web is a lower-cost edition licensed specifically for public, internet-facing web applications and hosting. It has a reduced feature set and a 16-core / 64 GB ceiling.

All three paid editions install with evaluation licensing. Apply a 25-character product key to license for production.

Free editions. Express is the free entry-level engine for small databases (10 GB maximum), prototypes and learning. It needs no product key and does not support backup compression. Developer is identical to Enterprise in features and is also free, but it is licensed strictly for development and test use only, never for production.

SQL Server 2022 features available across the paid editions (and in full on Developer) include Ledger for tamper-evident tables, Query Store on by default, intelligent query processing enhancements such as parameter-sensitive plan optimization, and contained availability groups.

What Every Edition Has in Common

  • Ubuntu 22.04 LTS base image with mssql-server, mssql-tools18 and sqlcmd from the official Microsoft APT repository.
  • Dedicated data volume. SQL Server data and log files live on their own gp3 EBS volume at /var/opt/mssql, separate from the OS disk and independently resizable.
  • No shared credentials. A one-shot first-boot service generates a unique SA password and a SecureAnyCloud SQL login on every instance, and writes them to /root/mssql-credentials.txt (mode 0600). Two instances never share credentials.
  • SQL Server on port 1433, started on boot via systemd. Open port 1433 only to trusted networks.
  • SSH login user ubuntu on every edition.
  • SecureAnyCloud 24/7 support for deployment, edition selection, high availability, tuning and administration.

The launch, connection, data-volume, backup and licensing steps differ by edition. Each edition's guide describes them in detail.

Prerequisites

  • An Amazon Web Services account where you can launch EC2 instances
  • IAM permissions to launch instances, create security groups and subscribe to AWS Marketplace products
  • An EC2 key pair in the target Region for SSH access
  • A VPC and subnet with a security group that allows inbound port 22 (and port 1433 from trusted networks for direct client access)
  • The AWS CLI (version 2) installed locally for command-line deployment

Support

SecureAnyCloud provides 24/7 technical support for these images. Contact sales@secureanycloud.com for help with SQL Server deployment, edition selection, performance tuning, high availability and administration.

For feature and edition details, see the official Microsoft SQL Server 2022 editions documentation.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Deploy on AWS

Launch SQL Server 2022 with 24/7 support from SecureAnyCloud.

View on Marketplace

Need Help?

Our support team is available 24/7.

sales@secureanycloud.com

Deploy on AWS