SQLTeam.com | Weblogs | Forums

Need help creating linked server from SS 2008 to SS 2014


#1

Hi, I am able to create a linked server from SS 2014 to SS 2008 (higher to lower version) without a problem, but in reverse, when I create a linked server from SS 2008 to SS 2014 (lower to higher version), I get the following error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)

Can someone please help me?


#2

Assuming the same domain is the Service Principal Name (SPN) for the 2014 server configured correctly? Are you using a registered SPN when establishing the linked server? Bing turned this up among other results: https://stackoverflow.com/questions/12462674/sql-server-returns-error-login-failed-for-user-nt-authority-anonymous-logon