Post reply

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. , but it works on the server

  • June 17, 2010 at 1:09 pm

    #139470

    I am attempting a select statement from a linked server table , using my credentials.

    When I run the statement on the host Server, via Management Studio, it works.

    When I run the statement from my desktop, logged into the host server, via Management Studio, I receive this error.

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

    Any ideas?

  • June 17, 2010 at 6:08 pm

    #1181886

    when you create a linked server, you have one of 4 security options to use as far as which credentials.

    I suspect that the first option shown in the screenshot below is currently selected, instead of the option i'm showing here:

    take a look at the security tabl on the linked server in question; the third option would use your credentials as you are expecting.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 17, 2010 at 8:39 pm

    #1181895

    You connected to your remote linked server from your local management studio ; the query you are executing, will that access data from remote server or your local server ? for example you are querying a view on remote server which contains "select * " of local server ?? if thats the case, then u are dealing with double hops issue, please google for SQL server Double Hops and you will get lot of information..

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

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