SQL Server Linked Server Authentication Issue After Windows 11 Upgrade

Veronika Komarov - X 0 Reputation points
Oct 10, 2024, 2:24 PM

After upgrading client machines to Windows 11, SQL Server Linked Servers configured with "Be made using login’s security context" authentication stopped functioning, resulting in the error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. What steps can be taken to resolve this issue?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,255 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,363 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Wesley Li 10,890 Reputation points
    Oct 11, 2024, 7:48 AM

    Hello

    It seems that the issue you're encountering with SQL Server Linked Servers after upgrading to Windows 11 is related to authentication and the Kerberos protocol.

    Linked Server Account Mapping Issue: You might encounter these error messages because of a linked server account mapping issue. You can correct this error by forcing TCP/IP or granting the appropriate permissions. In the Linked Server security dialog box, select "Be made with this security context" for a successful SQL Server login. When you select "Be made without using a security context" option, you will see the error message: "Login Failed for user NT AUTHORITY\ANONYMOUS LOGON" .

    Windows Defender Credential Guard: Disabling Windows Defender Credential Guard has been reported to resolve similar issues. You can manage Credential Guard settings through Group Policy .

    Group Policy Settings: Go to Group Policy and select LDAP for signing none in security settings, then try to go around RPC to authenticate everything and finally check Kerberos armoring in Group Policy with KDC. Try disabling Group Policy computer configuration and user configuration and restart the computer to try again .

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.