大网数据广告活动
数据库与应用安全

You can't use Kerberos unconstrained delegation in certain versions of Windows

· 52CE 我爱测

Provides a workaround for an issue where you can't use Kerberos unconstrained delegation in certain versions of Windows.

Note:

  • This article applies to Windows 10, Windows 11, Windows Server 2016, Windows Server 2019, and Windows Server 2022.
  • Full delegation is also known as "Kerberos unconstrained delegation".

Symptoms

You can't use linked servers or websites that delegate credentials to SQL Server in Windows 10, Windows Server 2016, and later versions. When testing connection to a linked server, you see an error like Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

Implications

If you use Windows 10, Windows Server 2016, or a later version with Credential Guard enabled on a network, you must switch all the servers from using full delegation to using constrained delegation.

If you try to run SQL Server Integration Services (SSIS) packages in SSISDB from a remote system, such as a client machine, via SQL Server Management Studio, the execution fails. The architecture of SSIS prevents it from being used with constrained delegation. Launching the jobs from a local SQL Agent should be fine as long as the back-end databases don't use linked servers.

Cause

Windows 10, Windows Server 2016, and later versions have a feature called Credential Guard. This feature prevents you from using credentials in full delegation scenarios.

Workaround

To work around this issue, use constrained delegation instead. If full delegation is required, disable Credential Guard in Group Policy.

More information

If you use Windows 10, Windows Server 2016, or a later version with the Credential Guard feature enabled, you can't use full delegation (trust this user for delegation to any service). You can only use constrained delegation.

Applications break if they require:

  • Kerberos DES encryption support
  • Kerberos unconstrained or full delegation
  • Extracting the Kerberos TGT
  • NTLMv1

For more information about the considerations and known issues when using Credential Guard, see known issues.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 01/16/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。