Post reply

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON")

  • August 12, 2013 at 8:49 am

    #297499

    I have a user who get this error when querying tables in another database from the same server.

    select * from AdOps.dbo.tblRCP_Source

    where name like '%american%egg%'

    and this is the error message: Msg 18456, Level 14, State 1, Line 1

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

    If they run the command from the adops database the query works. I have dealt with this error when it comes to linked servers but this database is on the same server. It happens to and from any database on the server, not just adops. Thanks...

  • August 19, 2013 at 4:00 pm

    #1642886

    If this issue has not been resolved yet, ask the user how he/she connects to SQL Server and compare this login to other logins who don't have this problem

    Yelena

    Regards,Yelena Varsha

  • August 20, 2013 at 4:28 am

    #1643002

    How the user is connecting and what permission does the login has.

    Regards
    Durai Nagarajan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply