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

by

Troubleshooting Guide: SQL Server Error 534 – Feature Not Supported in Edition

Why This Error Happens

Error 534 occurs when a T-SQL statement, database property, or feature (such as Change Data Capture, Compression, Partitioning, or Transparent Data Encryption) is invoked that is only available in Enterprise or Developer editions, while the instance is running Standard, Web, or Express edition. This commonly happens after restoring or attaching a database created on a higher-tier edition to a lower-tier SQL Server 2025 instance. The root cause is a licensing/edition mismatch rather than a configuration or corruption issue, meaning the server correctly identifies that the requested capability is disabled for the installed SKU.

Step-by-Step Resolution Guide

Step 1: Identify the Current Edition and the Feature Causing the Failure

  • Run the following query to confirm your current edition:
  SELECT SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('ProductVersion') AS Version;
  • Review the full error message text (it names the specific feature, e.g., “Change Data Capture” or “Compression”).
  • Cross-reference the feature against the Microsoft Docs “Editions and supported features of SQL Server 2025” matrix to confirm it is Enterprise-only.

Step 2: Disable or Remove the Unsupported Feature

  • If the database was restored from an Enterprise-edition backup, disable the specific feature before it runs again:
  EXEC sys.sp_cdc_disable_db;  -- Example for Change Data Capture
  • For compressed tables/indexes, rebuild them without compression:
  ALTER TABLE dbo.YourTable REBUILD WITH (DATA_COMPRESSION = NONE);
  • For partitioned tables, you must redesign the schema, as partitioning requires Enterprise edition.

Step 3: Upgrade the SQL Server Edition (If the Feature Is Required)

  • Open a Command Prompt as Administrator and run Setup with the edition upgrade switch:
  Setup.exe /q /ACTION=EditionUpgrade /INSTANCENAME=MSSQLSERVER /PID=xxxxx-xxxxx-xxxxx-xxxxx-xxxxx
  • Alternatively, launch SQL Server Installation Center on Windows Server 2025 or Windows 11, select “Maintenance” > “Edition Upgrade”, and follow the wizard.
  • Ensure you have a valid Enterprise or Developer edition product key (PID) before starting.

Step 4: Restart Services and Validate Configuration

  • Restart the SQL Server service via services.msc or PowerShell:
  Restart-Service -Name 'MSSQLSERVER'
  • Re-run SELECT SERVERPROPERTY('Edition') to confirm the upgrade took effect.
  • Re-execute the original script or job that triggered Error 534.

Alternative or Verification Steps

  • Verify success by re-running the exact operation that failed (e.g., enabling CDC or applying compression) and confirming no Error 534 is thrown.
  • If an edition upgrade is not feasible, use SQL Server Data Tools (SSDT) or Generate Scripts wizard to export the schema without Enterprise-only features, then redeploy to the Standard-edition instance.