How to fix Error 1712 on Windows Server 2025 / Windows 11

by

Troubleshooting Guide: Error 1712 – Online Index Operations Require Enterprise Edition

Why This Error Happens

This error occurs because the ONLINE = ON option for index creation or rebuild operations is an Enterprise-tier feature in SQL Server 2025, and the instance you are running is licensed under Standard, Web, or Express edition. SQL Server validates the edition SKU at the engine level before executing the index DDL statement, and if the feature flag for “Online Index Operations” is not present in that SKU, the engine immediately rejects the query with Error 1712. This is a licensing restriction rather than a configuration or permissions bug, so no amount of permission changes or server restarts will resolve it.

Step-by-Step Resolution Guide

Step 1: Confirm Your Current SQL Server Edition

  • Open SQL Server Management Studio (SSMS) or Azure Data Studio and connect to the instance.
  • Run the following query to check your current edition:
  SELECT SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('ProductVersion') AS Version;
  • If the result returns “Standard Edition,” “Web Edition,” or “Express Edition,” this confirms the root cause of Error 1712.

Step 2: Remove the ONLINE Clause from Your Index Script (Immediate Workaround)

  • Locate the CREATE INDEX or ALTER INDEX statement causing the failure.
  • Remove or set the ONLINE option to OFF so the operation runs as a standard offline index build:
  ALTER INDEX IX_YourIndexName ON dbo.YourTable REBUILD WITH (ONLINE = OFF);
  • Schedule this operation during a maintenance window, as offline rebuilds will place short-term locks on the table.

Step 3: Upgrade the SQL Server Edition (Permanent Fix)

  • If online index operations are a business requirement (e.g., for 24/7 uptime environments), you must upgrade to Enterprise Edition.
  • On Windows Server 2025, open the SQL Server Installation Center from the installation media or ISO.
  • Navigate to Maintenance > Edition Upgrade and provide a valid Enterprise Edition product key.
  • Restart the SQL Server service via services.msc or run:
  Restart-Service -Name 'MSSQLSERVER' -Force

Step 4: Evaluate Azure SQL Edge as an Alternative

  • If running in a containerized or IoT/edge scenario on Windows 11, confirm whether your workload is eligible for Azure SQL Edge, which natively supports online index operations outside the standard Enterprise licensing model.
  • Pull the latest Azure SQL Edge image via Docker if migrating:
  docker pull mcr.microsoft.com/azure-sql-edge:latest

Alternative or Verification Steps

  • Verify the Fix: After upgrading the edition or removing the ONLINE clause, re-run the original ALTER INDEX or CREATE INDEX script; it should complete without throwing Error 1712.
  • Alternative Check: Run SELECT * FROM sys.dm_server_services; to ensure the service is running under the updated license path, confirming the edition change was applied correctly at the engine level.