I have been reading through past posts but I am still getting issues with 2 SQL servers connecting using a linked server when querying from a 3rd SQL server. I constantly get the error "Login failed for user NT AUTHORITY\ANONYMOUS"
I have set the SPNs correctly using the Kerberos Configuration Manager provided by Microsoft for the service account SQL is running as on each machine. I have also been reading that if the computer contains a linked server then the computer object in AD needs trusting for delegation is that correct? Also do the service accounts need trusting for delegation?
I can't just make the changes to test so I need to get this right beforehand.