SQL Server 2022 Web on Ubuntu 22.04

## SQL Server 2022 Web on Ubuntu 22.04 by cloudimg

Microsoft SQL Server 2022 Web Edition on Ubuntu 22.04 LTS (Jammy Jellyfish), purpose built for Microsoft Azure and maintained by cloudimg. Web Edition is the cost effective SQL Server option for internet facing web workloads, designed for service providers and web hosting operators running public facing applications at scale.

Why Choose cloudimg?

* 24/7 Expert Support with guaranteed 24 hour response for all requests and one hour average for critical issues. Contact support@cloudimg.co.uk

* Production Ready from Launch Pre configured, security patched, and validated before publication

* Azure Native Integration Built with Azure Linux Agent, cloud init, and Gen2 Hyper V support

* Per VM Credential Generation Unique SA and cloudimg passwords generated at first boot and written to /stage/scripts/mssql-credentials.log. No shared credentials baked into the image

What is Included

* Microsoft SQL Server 2022 Web Edition installed from the official Microsoft APT repository pinned to Ubuntu 22.04 jammy for timely security patches

* mssql-tools18 command line utilities including sqlcmd and bcp for database administration

* mssql-firstboot.service systemd oneshot that rotates the SA password, creates the cloudimg default database, provisions a cloudimg SQL login, and removes the build time memory cap on first customer boot

* mssql-server.service systemd unit started automatically on boot after firstboot completes

* Ubuntu 22.04 LTS base with latest security patches applied at build time

* Azure Linux Agent for seamless cloud integration and SSH key injection

SQL Server 2022 Web Edition

SQL Server 2022 Web Edition is purpose built for public facing web workloads. It provides the SQL Server 2022 engine with features optimised for web hosting environments:

* Full T-SQL query language support

* In-memory OLTP for high throughput OLTP workloads

* JSON support for modern web API backends

* Always Encrypted for client side data protection

* Temporal tables for historical data tracking

* Row-Level Security for multi tenant applications

* Transparent Data Encryption (TDE) for at-rest data encryption

* Change Data Capture for real-time event streaming

* Azure Arc integration for hybrid management

* SQL Server 2022 Intelligent Query Processing

Licensing

SQL Server Web Edition is licensed under the Microsoft Services Provider License Agreement (SPLA). Customers must hold a valid SPLA agreement with Microsoft. Web Edition is intended for use in web hosted and internet facing application scenarios.

Technical Specifications

* Operating System: Ubuntu 22.04 LTS (Jammy Jellyfish)

* SQL Server Version: 2022 Web Edition (official packages.microsoft.com APT repo)

* Default Database: cloudimg

* SQL Port: 1433

* Default User: azureuser (sudo enabled)

* Service Management: systemd (mssql-server.service, mssql-firstboot.service)

* Recommended Size: Standard_D2s_v5 or larger

* VM Generation: Hyper V Gen2 with UEFI boot

Support

cloudimg provides 24/7/365 expert technical support. Guaranteed response within 24 hours, one hour average for critical issues. Contact support@cloudimg.co.uk or visit www.cloudimg.co.uk for the latest documentation and deployment guides.