Intermittent ANONYMOUS LOGON of SQL Server linked server double hop


If you already know how to configure the double-hop for SQL Server linked server, you may go « known issue » section directly.

 

Kerberos Delegation (double-hop scenario )

 

Here we will use Linked server scenario as an example. The 3 servers involved is Client, SQL Server 1 and SQL server 2. The first hop is from Client to SQL server 1 and the second hop is from SQL server 1 to SQL server 2.

 

 

 

 

One of the most common double hop failure scenarios we handle during connectivity troubleshooting goes like this.

 

Scenario

I