Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Login failed Error: 18456, Severity: 14, State: 11.

Posted on 2010-01-06
5
Medium Priority
?
459 Views
Last Modified: 2012-06-22
The above error says

"
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: <IPAddressOfServerA>]
Valid login but server access failure; Default Database access failure. Or Initial database connection failure in connection string.
"

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: <IPAddressOfServerB>]
also happens on the other direction.

Where could you affirm the credentials of  'NT AUTHORITY\ANONYMOUS LOGON' account, and that the other server can accept and trust the credentials.

thanks
0
Comment
Question by:anushahanna
  • 3
  • 2
5 Comments
 
LVL 13

Accepted Solution

by:
jaynir earned 2000 total points
ID: 26193916
well,

right click sql server management studio and Run as administrator.

Now you will be able to login.

after you succcessfully log in, go to sercurity and give sys admin privilege and you should be able to do it.
0
 
LVL 13

Expert Comment

by:jaynir
ID: 26193965
0
 
LVL 13

Expert Comment

by:jaynir
ID: 26194181
0
 
LVL 6

Author Comment

by:anushahanna
ID: 26199472
Under Server Role, NT AUTHORITY\SYSTEM is both 'public' and 'SA' in ServerA. Under 'User Mapping', he does not have any specific database chosen, because he is SA, and also Windows Authentication is what he has under the properties. It is the same in ServerB. ServerA & B are trying to communicate , and both get the same error. Both servers all mixed authentication.

the links talked about the server having linked server. But neither of these servers have any LS..

is the way the login('NT AUTHORITY\SYSTEM') is setup ok?

thanks
0
 
LVL 6

Author Comment

by:anushahanna
ID: 26199571
just noticed that the error says 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. and the login is 'NT AUTHORITY\SYSTEM' which is a windows login, is that my problem?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question