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

by

Troubleshooting Guide: Error 7224 – “Enabling ‘remote proc trans’ is not supported on this instance”

Why This Error Happens

This error occurs when an application or script attempts to enable the remote proc trans configuration option using sp_configure on an edition or instance of SQL Server that does not support distributed transactions coordination for remote stored procedure calls. In SQL Server 2025, this option is typically deprecated or restricted on certain editions (such as Express or Web Edition) and requires the Microsoft Distributed Transaction Coordinator (MS DTC) service to be properly installed and configured. Additionally, this can occur if the instance is running in a container or minimal installation that excludes the DTC-dependent components.

Step-by-Step Resolution Guide

Step 1: Verify SQL Server Edition Compatibility

  • Run SELECT SERVERPROPERTY('Edition'); in SQL Server Management Studio (SSMS) to confirm your current edition.
  • Note that remote proc trans is unsupported on SQL Server Express and certain Azure-integrated editions.
  • If running an unsupported edition, consider upgrading to Standard or Enterprise Edition to enable this feature.

Step 2: Check and Install MS DTC on Windows Server 2025 / Windows 11

  • Open Server Manager > Add Roles and Features > Navigate to Features.
  • Ensure Distributed Transaction Coordinator is checked and installed.
  • Alternatively, run the following PowerShell command as Administrator:
  Install-WindowsFeature -Name "MSMQ, NET-Framework-45-Core"
  • Restart the Distributed Transaction Coordinator service via services.msc.

Step 3: Reconfigure SQL Server Instance Settings

  • Open a new query window in SSMS and execute:
  EXEC sp_configure 'show advanced options', 1;
  RECONFIGURE;
  EXEC sp_configure 'remote proc trans', 1;
  RECONFIGURE;
  • If the error persists, check the SQL Server error log located at C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\Log\ERRORLOG for additional context.

Step 4: Validate DTC Network Access Settings

  • Open dcomcnfg (Component Services) on the Windows Server 2025 / Windows 11 machine.
  • Navigate to Component Services > Computers > My Computer > Distributed Transaction Coordinator > Local DTC.
  • Right-click Local DTC, select Properties, and ensure Network DTC Access is enabled under the Security tab.
  • Apply changes and restart the MS DTC service for the settings to take effect.

Step 5: Restart SQL Server Services

  • Open services.msc and restart the SQL Server (MSSQLSERVER) service.
  • Restart the SQL Server Agent service as well to ensure configuration changes are fully applied.
  • Confirm no pending restart is required by checking Windows Update history.

Alternative or Verification Steps

  • To verify the fix, re-run EXEC sp_configure 'remote proc trans'; and confirm the config_value and run_value are both set to 1 without triggering Error 7224.
  • If the issue persists, consider using Linked Servers with sp_addlinkedserver instead of remote proc trans, as this provides an alternative method for executing remote procedure calls without relying on this deprecated configuration option.