错误：18456，严重性：14，状态：11。 [英] Error: 18456, severity: 14, state: 11.

问题描述

hi all,

pls help me to resolve this issue.
i am using sql server2008r2 sp2

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: xxx.xx.xx.xx]

thanks in advance.

regards
Ganesh

我尝试过：



禁用服务器uac。并试过但同样的问题

i也被域名帐户试过。

无法连接应用程序。

What I have tried:

disabled server uac. and tried but same problem
i tried by domain account also .
unable connect application.

推荐答案

基本上，这是一个登录问题，很可能是底层的Windows用户信息。

如果你得到一个你不明白的错误，首先要做的就是google it：错误：18456，严重性：14，状态：11 - 谷歌搜索 [ ^ ] - 这会让很多其他人遇到同样的问题。

关注一些链接，看看如果他们所描述的正是你正在做的事情 - 我们不知道你如何连接到SQL，它可能是通过SSMS，你自己的应用程序，现成的应用程序，或任何东西。每个解决方案都会有很大差异。

但最有可能的是，您需要在连接时明确指定用户登录信息，而不是尝试匿名或Windows身份验证登录。

Basically, it's a login problem, most likely with the underlying Windows user info.
If you get an error you don't understand, the first thing to do is google it: Error: 18456, severity: 14, state: 11 - Google Search[^] - that gives you a lot of other people who have met the same problem.
Follow a few of the links, and see if what they are describing is exactly what you are doing - we have no idea how you are connecting to SQL, and it could be via SSMS, your own app, an off the shelf app, or anything. And the solution would be vastly different for each.
But the most likely is that you need to specify the user login info explicitly when you connect instead of trying an anonymous or "Windows Authentication" login.

18456，严重性：14，状态：11是基于登录的服务器访问验证失败，基础结构错误



修复此错误以管理员身份运行SQL Server Management Studio或禁用UAC



查看这些链接以获取有关错误消息的更多信息

如何解决Microsoft SQL Server登录失败错误18456？

SQL Server错误18456：知道如何修复？

18456, Severity: 14, State: 11 is login-based server access validation failed with an infrastructure error

To fix this error run SQL Server Management Studio as administrator or disable UAC

Check out these links for more information on the error message
How to Resolve Microsoft SQL Server Login Failed Error 18456?
SQL Server Error 18456: Know How to Fix?

这篇关于错误：18456，严重性：14，状态：11。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！