Overview
SQL Server 2022 Enterprise on Ubuntu 22.04 installed and configured: CU28 with core-based licensing, a per-instance sa password and TLS certificate, localhost-only with TLS forced, and an OS updated at build, for large and mission-critical 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 Enterprise 16.0.4325.4 (CU28, core-based licensing) on Ubuntu 22.04 LTS from Microsoft's official repository, with sqlcmd and ODBC Driver 18: Microsoft's edition for large and mission-critical databases
- A unique 32-character sa password and TLS certificate made on each instance's first boot, in a root-only file; SQL Server listens on 127.0.0.1:1433 with TLS forced, reached through an SSH tunnel
- Telemetry, xp_cmdshell and CLR off, SQL Server Agent off until you enable it, metadata blocked for SQL Server, IMDSv2 required. 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 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 certificate, so no two instances share a password, key or SQL Server instance identity, and no build-time password ships.
- 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, xp_cmdshell, OLE Automation, CLR and remote admin connections off, SQL Server Agent off until you enable it, and SQL Server blocked from the instance metadata service.
- Ubuntu 22.04 fully updated at build with unattended security updates on, key-only SSH as ubuntu, root locked, IMDSv2 required, and no build residue: no shared keys, default passwords or build logs, and unused disk space zero-filled before capture.
About SQL Server 2022 Enterprise
SQL Server 2022 Enterprise Edition (core-based licensing) 16.0.4325.4 (Cumulative Update 28) from Microsoft's official packages.microsoft.com repository, with sqlcmd and the ODBC Driver 18 on board. SQL Server 2022 Enterprise is bring your own licence: no SQL Server licence is included or sold with this listing. You need SQL Server 2022 Enterprise 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 at first boot; there is no product key to enter. The $0.04 per vCPU-hour charge covers what cloudimg adds to SQL Server: the per-instance sa password and certificate set up on first boot, the closed-by-default network and forced TLS, and the instance hardening above. AWS infrastructure charges are extra.
Network and access
- Use an instance 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; the sa password is in /root/mssql-credentials.txt (root only).
- 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. Ubuntu is a trademark of Canonical Ltd. cloudimg is not affiliated with or endorsed by Microsoft or Canonical.
Related technologies
sql server 2022 enterprisesql server enterprisesql server 2022microsoft sql servermssqlsql server on linuxsql server ubuntusql server amisql server cu28license mobilityrelational databaseoltpt-sqlsqlcmdubuntu 22.04