SQL Server 2008 Error

• Todd Melcher

  SSC Enthusiast

  Points: 132

  More actions

  December 6, 2011 at 9:29 am

  #391049

  If I run this simple statement on SQL 2005 SP3, I get a result set back

  SELECT * FROM servername.dbname.dbo.tablename

  However, If I run this same statement on SQL 2008 R2

  I get the following error.

  Msg 18456, Level 14, State 1, Line 1

  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  Can anyone explain why I might be getting this error?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  December 6, 2011 at 9:36 am

  #1417475

  The linked server is not configured properly on 2008. See how you did it on 2005 and redo on 2008 (that can be scripted if you want).