cloudimg Microsoft SQL Server 2022 Database AMI

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Microsoft SQL Server 2022 is the enterprise relational database platform for mission-critical workloads, analytics, and high availability. This AMI delivers SQL Server 2022 fully installed and configured so your database server is running within minutes of launch - no manual setup, no shared default passwords, and no data mixed onto the OS disk.

This listing is built for DBAs and engineering teams migrating from on-premises SQL Server, SaaS companies scaling their data tier on AWS, and organizations that need expert support without hiring dedicated database infrastructure staff.

Choose the delivery option that matches your workload:

• Enterprise - Full feature set for mission-critical scale, ledger tables, and contained availability groups
• Standard - Mid-tier production workloads with core database engine features
• Web - Low-cost edition for public web-facing applications and hosting
• Express - Free entry-level edition for small databases (ideal for evaluating this AMI at no software cost before upgrading)
• Developer - Complete Enterprise feature set licensed for development and test use only

Buyers can launch the Express or Developer edition to evaluate the AMI, the dedicated volume layout, and the first-boot credential flow before committing to a paid edition.

Many competing SQL Server AMIs store database files on the root volume, ship with shared default passwords, and offer no included support. cloudimg addresses each of these pain points:

• Isolated data volume - Your database files live on a dedicated gp3 EBS volume at /var/opt/mssql, separate from the OS disk. Resize storage independently without snapshots of the entire root volume.
• Secure first boot - A one-shot systemd service generates a unique SA password and cloudimg SQL login on every new instance. No shared or default credentials ship in the image.
• 24/7 expert support - Critical issues receive a one-hour average response. Get help with deployment, edition selection, HA configuration, performance tuning, and backup strategy.

• mssql-server from the official Microsoft APT repository
• mssql-tools18 and sqlcmd for command-line administration
• Service runs on port 1433 and starts on boot via systemd
• TLS enforced for client connections

• Ledger for tamper-evident tables
• Query Store enabled by default
• Intelligent query processing with parameter-sensitive plan optimization
• Contained availability groups
• Built-in query intelligence and security hardening

SQL Server data and log files reside on a dedicated gp3 EBS volume mounted at /var/opt/mssql. The gp3 baseline delivers 3,000 IOPS and 125 MiB/s throughput, independently scalable as your database grows - without touching the OS disk.

On first boot a one-shot service generates a unique SA password, creates a cloudimg SQL login, removes the build-time memory cap, and writes all credentials to /root/mssql-credentials.txt (root access required). No shared or default credentials exist in the image.

A SaaS provider running a multi-tenant web application on AWS launches the Web edition on an r6i.xlarge instance. Their 200 GB transactional database handles real-time OLTP during the day and nightly ETL jobs. The dedicated gp3 volume is scaled to 6,000 IOPS for peak load, and cloudimg support assists with Query Store tuning and automated backup configuration.

Retrieve credentials from /root/mssql-credentials.txt and connect with sqlcmd or any SQL Server client on port 1433. Need help choosing the right edition or instance size? Contact cloudimg for a free deployment review.

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.