Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' Expand / Collapse
Author
Message
Posted Thursday, August 7, 2008 5:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
hi,
i have read all the comments as well as suggestion but my problem is little bit different ,i have two servers .i am executing a query on linked server...its giving below wriiten error

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.


i have checked sql server agent login on both servers .both have same login name with same rights.
still it is giving error


Can any one suggest any solution??


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #548186
Posted Thursday, August 7, 2008 8:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:23 AM
Points: 1,045, Visits: 1,115
The user should give you a clue here - Anonymous login failed. So, there is no point checking your username/passwords; they are not being used. One server is trying to authenticate to the other user an anonymous login; in other words, it is not presenting any logon credentials.

You need to check your set up. Under what user should the logon process be running? Is it a service account or a specific user?

I would guess that a "Local System" or "Network Service" account is being used; these accounts are only recognised on the local system. Although in some cases the Network Service can appear as ServerName$.

Andy
Post #548339
Posted Monday, December 8, 2008 9:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, April 3, 2010 2:42 PM
Points: 1,023, Visits: 1,893
I have the same error but when i check on both servers it gave me

net_transport auth_scheme
------------- ---------------
TCP NTLM
Post #615649
Posted Tuesday, December 9, 2008 1:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:23 AM
Points: 1,045, Visits: 1,115
NTLM authentication will work fine, as long as neither server is configured to disallow this "lower" level of authentication (lower when compared to kerberos).

If you are in a AD domain, then as long as the Windows Services on both servers are running under the same credentials, you should be ok. Having said that, in this configuration, kerberos should be used by default.

If not in a domain, then it gets harder. The normal solution is to have exactly matched username/password accounts on both servers.

Andy
Post #615968
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse