Ss

SQL Server 2022 Standard on Windows Server 2022

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 Windows Server 2022 installed and configured: CU28, a unique sa password per instance, port 1433 closed, Microsoft Security Baseline applied. It runs as Evaluation until you apply your own Standard key with the helper. 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 binaries (16.0.4325.4, CU28) on Windows Server 2022 Datacenter, completed on each instance at first boot: its own server name, service master key and a random sa password in an Administrators-only file
  • Starts as Evaluation (180 days from first boot) until you apply your own Standard key with the included Set-SqlStandardEdition.ps1 helper. Windows licence in the Amazon EC2 price; bring SQL Server through License Mobility
  • Microsoft Security Baseline applied and measured with HardeningKitty, report on the instance; port 1433 closed by default, SQL Browser and telemetry off, Remote Desktop with NLA only, IMDSv2 required

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

  • SQL Server sysprep: the image carries the SQL Server 2022 binaries only (Microsoft's prepare-image step), with no instance, no system databases, no service master key and no sa password. A one-time first-boot task completes SQL Server on your instance, so the server name, the service master key, the system databases and a random sa password are unique to every instance. First boot proves the new password logs in and a wrong one is refused before it writes it to C:\ProgramData\cloudimg\mssql\mssql-credentials.txt (Administrators and SYSTEM only).
  • Port 1433 closed by default: SQL Server listens on TCP 1433, but the Windows Firewall has no inbound rule for it and the security group opens Remote Desktop (3389) only, so you open 1433 to your own network when you choose. Named Pipes off; the SQL Server Browser and SQL Server telemetry (CEIP) services disabled.
  • Microsoft Security Baseline for Windows Server 2022 (Member Server), applied with Microsoft's LGPO tool and measured with HardeningKitty; the report, the rules waived for Amazon EC2 and their reasons ship in C:\ProgramData\cloudimg\baseline. This is a measurement against Microsoft's published baseline, not a certification.
  • Windows Server 2022 Datacenter fully updated at build time, with a unique Administrator password, machine SID and Remote Desktop certificate on every instance; Remote Desktop with Network Level Authentication; IMDSv2 required.
  • An edition-upgrade helper, C:\ProgramData\cloudimg\mssql\Set-SqlStandardEdition.ps1, that runs Microsoft's Edition Upgrade with your own SQL Server 2022 Standard product key and checks the edition afterwards. The SQL Server setup media stays in C:\SQLServerSetup.
  • SQL Server 2022 from Microsoft's own installation media (checksum-pinned, Microsoft-signed setup) with the latest cumulative update at build time; sqlcmd on the PATH and local Administrators in the sysadmin role.

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. Microsoft does not allow Standard to be activated without the buyer's own product key, so the instance starts as SQL Server 2022 Evaluation (180 days from first boot) until you apply your Standard key with C:\ProgramData\cloudimg\mssql\Set-SqlStandardEdition.ps1; apply it before production use. The Windows Server licence is included by AWS in the Amazon EC2 instance price. The $0.04 per vCPU-hour charge covers what cloudimg adds: SQL Server sysprep with a unique instance, sa password and service master key on every instance, the Microsoft Security Baseline hardening, port 1433 closed by default, the Windows Server base updated at build, the first-boot automation and the edition-upgrade helper. AWS infrastructure charges, which include the Windows Server licence, are extra.

Network and access

  • Use an instance type with at least 4 GiB of memory (t3.medium or larger); m5.large is recommended. The listing charges the same rate per vCPU on every instance type it offers.
  • Connect with Remote Desktop on port 3389 as Administrator, with the password from Get Windows password in the Amazon EC2 console and your key pair. Allow about 15 minutes after launch for first boot to complete SQL Server.
  • Restrict the security group's 3389 source to your own address range. Never open 1433 to the internet: open it to your own network only, in both the Windows Firewall and the security group.

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

Trademarks

Microsoft, SQL Server and Windows Server are trademarks of the Microsoft group of companies; cloudimg is not affiliated with Microsoft.

Related technologies

sql server 2022 standardsql server 2022sql server standardmicrosoft sql servermssqlsql server windowswindows server 2022sql server amisql server cu28license mobilityrelational databaset-sqlsqlcmdsecurity baselinerdp