Help! NT AUTHORITY\ANONYMOUS LOGON Error Msg

• RazorbackDBA

  SSC Eights!

  Points: 897

  More actions

  June 5, 2014 at 1:19 am

  #286271

  Hello all,

  I am running into the problem with NT Authority\Anonymos Logon when I run it against VIEWS that I built on my Server. I am sure it must be a permissions problem. My views are built using Linkservers. I can excute the select statement from the server, but when I try from a work station I get the logon error. Any thoughts??

  Thanks

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  June 5, 2014 at 6:22 am

  #1719172

  Hi, this sounds like a double-hop issue. You can read about it on http://www.mssqltips.com/sqlservertip/2312/understanding-when-sql-server-kerberos-delegation-is-needed/

  When you search the internet you can find a lot of information about it.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **