Overview
SQL Server 2022 Developer on Windows Server 2022 installed and configured: a unique sa password per instance, port 1433 closed by default, and an OS updated at build. Developer edition, licensed for development and testing, needs no SQL Server licence. 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
- SQL Server sysprep: the instance is completed on your instance at first boot, with its own sa password, service master key and server name; no build-time password ships
- Closed by default: 1433 listens but is shut in the Windows Firewall and the security group; named pipes, SQL Server Browser and CEIP telemetry off; Remote Desktop with NLA only
- SQL Server 2022 Developer CU28 on Windows Server 2022, fully updated at build, with the Microsoft Security Baseline (319 of 320 rules pass); licensed by Microsoft for development and test, not production
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, and the instance is completed on your instance at first boot, so the server name, service master key, system databases and a random sa password are unique to every instance. The sa password is written to C:\ProgramData\cloudimg\mssql\mssql-credentials.txt, which only Administrators and SYSTEM can read; no build-time password ships.
- 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. Named pipes are off, and the SQL Server Browser and CEIP telemetry services are disabled.
- Microsoft Security Baseline for Windows Server 2022 (Member Server), applied with Microsoft's LGPO tool and measured with HardeningKitty v.0.9.4 on a fresh instance: 319 of 320 scored rules pass (99.7%), with 8 rules waived for Amazon EC2, each with its reason. The report ships 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 (OS build 20348.5870), Remote Desktop with Network Level Authentication only, a unique Administrator password on every instance through EC2Launch v2, IMDSv2 required, and no build residue: build tools and logs removed and unused disk space wiped before capture.
About SQL Server 2022 Developer
SQL Server 2022 Developer edition 16.0.4325.4 (Cumulative Update 28, KB5125472), installed from Microsoft's own SQL Server 2022 media with sqlcmd, on Windows Server 2022 Datacenter. Developer edition has every Enterprise edition feature. Licensing: Microsoft licenses Developer edition for development, test and demonstration only, and it must not be used in production. It needs no SQL Server licence, and this listing sells none. 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 to SQL Server and Windows Server: the SQL Server sysprep with a per-instance sa password, service master key and server name, the closed-by-default network, the Microsoft Security Baseline with its on-image report, and the Windows Server 2022 image updated at build. AWS infrastructure charges, including the Windows Server licence in the instance price, are extra.
Network and access
- Use an instance with at least 4 GiB of memory (t3.medium or larger); m5.large is recommended.
- Sign in with Remote Desktop on port 3389 as Administrator, with the password from Get Windows password and your key pair. The suggested security group allows RDP from anywhere: change the source to your own IP.
- On the instance, sqlcmd -S localhost -E works for Administrators; the sa password is in C:\ProgramData\cloudimg\mssql\mssql-credentials.txt.
- To reach SQL Server from your network, open 1433 in the Windows Firewall and the security group to your own network only, never to 0.0.0.0/0.
Contact: support@cloudimg.co.uk or 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 or endorsed by Microsoft.
Related technologies
sql server 2022sql server developermssqlwindows server 2022sqlcmdt-sqlrelational databasesql server sysprepsecurity baselineremote desktopdev and testdatabase