Help! I've reached the limits of my knowledge as a humble DBA. Here's the problem -
PC #1 in London
SQL Server #1 in Berlin
SQL Server #2 in Berlin
SQL Server #3 in London
There's a linked server called [Svr1-Svr2] between SQL Server #1 and SQL Server #2.
There's a linked server called [Svr2-Svr3] between SQL Server #2 and SQL Server #3
SPNs have been set for all 3 SQL Servers and I have confirmed the authentication method is Kerberos by running [b][font="Courier New"]select auth_scheme from sys.dm_exec_connections where
John Doe logs into PC #1 and can use the linked server [Svr1-Svr2] to get data. He cannot use linked server [Svr2-Svr3] and gets Err 18456 i.e. the double-hop err.
there is a firewall between London and Berlin. What must I ask my firewall admin to do to allow kerberos to pass through it?
View Complete Post