SQL Server IoT
What is SQL Server IoT?
SQL Server IoT is a special license-only edition of Microsoft SQL Server, designed specifically for embedded and dedicated-purpose devices. It provides the same binaries and capabilities as the commercial version of SQL Server, including support for advanced analytics and seamless cloud integration with Azure services. However, it is distributed exclusively through the OEM embedded channel and intended for use in fixed-function appliances.
How is SQL Server IoT different from commercial SQL Server?
While both versions offer the same technical capabilities, SQL Server IoT is sold only through the OEM IoT channel and is licensed on a per-device basis using a Certificate of Authenticity (COA). In contrast, commercial SQL Server is available via volume or CSP licensing and follows per-user, per-core, or per-VM licensing models.
SQL Server IoT is intended for fixed-purpose appliances with pre-installed, single-purpose applications, whereas the commercial version is suited for broad enterprise use. From a cost perspective, SQL Server IoT is significantly more economical for OEM deployments.
What types of devices benefit from SQL Server IoT?
SQL Server IoT is ideal for OEM-built appliances that require robust data handling and reliability. These include medical data management systems, retail point-of-sale (POS) back-end analytics, industrial edge servers for telemetry and diagnostics, and telecommunications servers with integrated analytics.
How is SQL Server IoT licensed?
SQL Server IoT offers two licensing options:
- Server + CAL: Purchase a SQL Server instance license and acquire separate Client Access Licenses (CALs) for each user or device that accesses the server.
- Per Core: Purchase SQL Server Per Core licenses, with a minimum of four cores. This option allows for unlimited users and devices.
Can I run SQL Server IoT on a virtual machine (VM)?
Yes, SQL Server IoT can run on a VM; however, the licensing requirements apply to the physical host machine. OEMs must still license all physical cores of the host system if SQL Server IoT is deployed in a virtualized environment, similar to standard SQL Server licensing policies.
Can I use SQL Server IoT in regulated industries?
Absolutely. SQL Server IoT includes advanced features like SQL Ledger, which provides cryptographic verification of data changes. This makes it particularly well-suited for industries with strict regulatory requirements such as finance, healthcare, and government sectors.
I have received a SQL Server IoT COA, where is the product activation key?
The product activation key for SQL Server is already embedded in the OPK which you can download from www.microsoftoem.com.
