Ss

SQL Server 2022 Express

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 Express on Ubuntu 22.04 installed and configured: a per-instance sa password and TLS certificate, localhost-only with TLS forced, and an OS updated at build. Express edition needs no SQL Server licence (within its size limits). Microsoft and SQL Server are trademarks of Microsoft; 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

  • A unique sa password and TLS certificate on every instance, made by Microsoft's own setup on first boot; no build-time password ships
  • Closed by default: SQL Server on 127.0.0.1:1433 only, SSH-only security group, TLS forced on every connection, telemetry off
  • SQL Server 2022 Express CU28 on Ubuntu 22.04 fully updated at build; this listing sells no SQL Server licence, and Express needs no licence purchase within its limits

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 and TLS certificate on every instance: first boot runs Microsoft's own unattended setup with a fresh 32-character sa password and a per-instance RSA-3072 certificate, so no two instances share a password, key or SQL Server instance identity, and no build-time password ships.
  • Fail closed: SQL Server refuses to start until first boot has finished; if first boot cannot complete, SQL Server stays stopped and the next boot tries again.
  • Closed by default: SQL Server listens on 127.0.0.1:1433 only and the security group opens SSH only. Reach SQL Server through an SSH tunnel, or open 1433 deliberately when you need to.
  • TLS forced on every connection (TLS 1.2) with the per-instance certificate, telemetry (CEIP) off, SQL Server Agent off, xp_cmdshell, OLE Automation, CLR, ad hoc distributed queries and remote admin connections off, and SQL Server and its first-boot service blocked from the instance metadata service.
  • Ubuntu 22.04 fully updated at build with unattended security upgrades on, key-only SSH as ubuntu, root locked, IMDSv2 required, and no build residue: no shared keys, default passwords or build logs.

About SQL Server 2022 Express

SQL Server 2022 Express Edition 16.0.4325.4 (Cumulative Update 28) from Microsoft's official packages.microsoft.com repository, with sqlcmd (mssql-tools18) and the Microsoft ODBC Driver 18 on board. SQL Server 2022 adds ledger tables, Query Store hints, parameter-sensitive plan optimization and new JSON functions in T-SQL. Licensing: this listing sells no SQL Server licence; Express needs no licence purchase within its limits, which Microsoft sets under the Microsoft Software License Terms: compute, the lesser of 1 socket or 4 cores; memory, 1410 MB buffer pool; size, 10 GB per database; no SQL Server Agent. A workload beyond those limits needs another SQL Server edition and its own licence from Microsoft, which you bring yourself. The $0.04 per vCPU-hour charge covers only what cloudimg adds to SQL Server 2022 Express on Ubuntu 22.04: a unique sa password and TLS certificate made on every instance's first boot, the localhost-only listener with TLS forced, the SQL Server hardening and metadata block, and the key-only Ubuntu 22.04 image updated at build, plus your AWS infrastructure charges. It is priced at the same rate per vCPU on every instance type this listing offers.

Network and access

  • Use an instance with at least 4 GiB of memory (t3.medium or larger); m5.large is recommended.
  • Log in over SSH on port 22 as ubuntu with the Amazon EC2 key pair you choose at launch; the sa password is in /root/mssql-credentials.txt (root only). The suggested security group allows SSH from anywhere: change the source to your own IP.
  • Connect from your workstation with ssh -L 1433:127.0.0.1:1433 and any SQL Server client with encryption on.

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

Trademarks

Microsoft and SQL Server are trademarks of the Microsoft group of companies; cloudimg is not affiliated with or endorsed by Microsoft. Ubuntu is a trademark of Canonical Ltd.

Related technologies

sql server 2022sql server expressmssqlsql server on linuxubuntu 22.04sqlcmdt-sqlrelational databasetlsssh tunnelledger tablesdatabase