SQL Server 2008R2 linked from a SQL2012 server problem

• Joe.Spitler

  Say Hey Kid

  Points: 691

  More actions

  July 11, 2013 at 12:51 pm

  #395121

  I have a 2012 server with link to a 2008r2 server. When I run a simple select from the 2012 query window and specify the fully qualified linked server (2008r2) the query runs fine.

  When I log into the 2008R2 server, launch SSMS (2008R2) but connect to the 2012 server and run the same query i get the 18456 'NT Authority\Anonymous Logon' error.

  Further, When I connect to the the 2012 server from a client PC using SSMS (2012), I get the same error when I run the query from the linked 2008R2 server. Using the fully qualified name.

  Any thoughts?

  Thanks.

  Joe

• JeremyE

  SSCoach

  Points: 16199

  More actions

  July 11, 2013 at 1:49 pm

  #1631728

  It's known as a double hop issue. You need to setup delegation or use a SQL login for the linked server.

  http://msdn.microsoft.com/en-us/library/ms189580(v=sql.105).aspx