Blog Post

SQL Server Support Blog
6 MIN READ

Intermittent ANONYMOUS LOGON of SQL Server linked server double hop

lduan_dsd's avatar
lduan_dsd
Icon for Microsoft rankMicrosoft
Dec 12, 2022
If you already know how to configure the double-hop for SQL Server linked server, you may go "RARE SCENARIO" section directly.   Kerberos Delegation (double-hop scenario )   Here we will use ...
Updated Jan 09, 2023
Version 6.0
Linked Server
brlgen's avatar
brlgen
Brass Contributor
Sep 29, 2023

I believe there is an issue on Windows Server 2016 that is being access using Remote Credential Guard over RDP. When a client accesses such server and then when you open up SQL mgmt studio for example to a different different SQL Database server it throws this error. However on 2019+ servers the issue is not present. Remote Credential guard is supported since 2016 but yet this functionality in combination with SQL only seems to work on 2019+. Is this maybe a bug or can this somehow be resolved too?