Ss

SQL Server 2022 Standard

AWS Databases
Base
Hardened build
minimal ports, security patches applied at build time
Access
Unique credentials
generated on first boot, readable only by root
Verified
Boots working
services pass a health gate before release
Support
24 hours a day
by email, guaranteed response within 24 hours

Overview

SQL Server 2022 Standard on Ubuntu 22.04 installed and configured: CU28 with sqlcmd and ODBC 18, a per-instance sa password and TLS certificate, localhost-only with TLS forced, and an OS updated at build, for departmental and mid-size databases. Bring your own SQL Server licence (License Mobility). cloudimg is not affiliated with Microsoft.

Why the cloudimg image

This image arrives installed, configured and hardened, so there is no manual setup before you can use it. It is built on a patched base, runs with credentials generated uniquely for your instance on first boot, and passes an automated health check before every release. cloudimg's support team is on hand 24 hours a day by email, with a guaranteed response within 24 hours.

Key features

  • SQL Server 2022 Standard 16.0.4325.4 (CU28) on Ubuntu 22.04 LTS from Microsoft's official repository, with sqlcmd, bcp and ODBC Driver 18: a relational database for departmental and small-to-midsize workloads
  • A unique sa password and TLS certificate made on each instance's first boot by Microsoft's own setup, in a root-only file; SQL Server listens on 127.0.0.1:1433 with TLS 1.2 forced, reached through an SSH tunnel
  • Telemetry, xp_cmdshell and CLR off, SQL Server blocked from instance metadata, IMDSv2 required, unattended security upgrades on. Bring your own licence through License Mobility with Software Assurance

Description

This is a repackaged software product wherein additional charges apply for security hardening, secure-by-default configuration and per-instance setup.

What cloudimg adds

  • A unique sa password minted on each instance's first boot by Microsoft's own unattended setup: the image ships SQL Server installed but not set up, with no master database, no sa password and no machine key. The password is written to /root/mssql-credentials.txt, readable by root only.
  • A per-instance TLS key and self-signed certificate, with encryption forced on every connection and TLS 1.2 only.
  • SQL Server listens on 127.0.0.1:1433 only and the security group opens SSH only: reach the database through an SSH tunnel, or open the listen address yourself for named hosts in your VPC.
  • SQL Server and its first-boot service are denied the instance metadata service, and the AMI requires IMDSv2.
  • Microsoft's customer feedback telemetry off; SQL Server Agent, xp_cmdshell, OLE Automation, CLR, ad hoc distributed queries and remote admin connections off.
  • Fail closed: SQL Server will not start until first boot has finished, so no instance runs without its own sa password.
  • Ubuntu 22.04 LTS fully updated at build time, with unattended security upgrades on.
  • SQL Server 2022 Standard 16.0.4325.4 (CU28), mssql-tools18 (sqlcmd, bcp) and the ODBC Driver 18 from Microsoft's official packages.microsoft.com repositories, with the signing key pinned.

About SQL Server 2022 Standard

SQL Server 2022 is Microsoft's relational database engine; Standard is its edition for departmental and small-to-midsize workloads, within Microsoft's Standard limits on cores and memory. SQL Server 2022 Standard is licensed by Microsoft per core, and no SQL Server licence is included in or sold with this listing. You need SQL Server 2022 Standard core licences with active Software Assurance (License Mobility through Software Assurance), verified with Microsoft for AWS. Licences without Software Assurance cannot be brought to AWS for SQL Server 2022. The edition is set by name at first boot; there is no product key to enter. The $0.04 per vCPU-hour charge covers what cloudimg adds: the per-instance first-boot setup of the sa password and TLS certificate, the localhost-only configuration with forced TLS, the metadata block and the Ubuntu 22.04 base updated at build. AWS infrastructure charges are extra.

Network and access

  • Use an instance type with at least 4 GiB of memory (t3.medium or larger).
  • Log in over SSH on port 22 as ubuntu with the key pair you choose at launch, then read the sa password with sudo cat /root/mssql-credentials.txt.
  • Connect clients through an SSH tunnel to 127.0.0.1,1433 with encryption on. Do not open 1433 to the internet.

Contact: https://www.cloudimg.co.uk/support

Trademarks

Microsoft and SQL Server are trademarks of Microsoft; cloudimg is not affiliated with Microsoft. Ubuntu is a registered trademark of Canonical Ltd.; cloudimg is not affiliated with Canonical.

Related technologies

sql server 2022 standardsql server 2022sql server standardmicrosoft sql servermssqlsql server on linuxsql server ubuntusql server amisql server cu28license mobilityrelational databaseoltpt-sqlsqlcmdubuntu 22.04