I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
If I then run the same query on my older machine without Windows 10, I have no problems and never ever had any problems.
Now the funny part begins: If I run the query from my old PC (logged on with the same credentials) and then within 5 minutes run the same query from my Windows 10 machine - there is no problem!
It's like if my old machine establishes a connection that is open for about 5 minutes and then times out, and my Windows 10 machine cannot find out how to establish that connection.
I am just running a query in SSMS logged onto server A querying data from a database on server B, and doing the same thing on both machines.