blocks|key|5434301|text|具有与此0x8009030c代码完全相同的消息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5434302|在我的例子中，用户没有从网络访问sql计算机的权限，我收到了一条失败的审计消息，指出了这一点(我认为在其他情况下也会出现同样的消息)。|5434303|转至:本地安全策略->安全设置->本地策略->用户权限分配->从网络访问此计算机->添加用户|5434304|它解决了这个问题|5434305|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Had the same exact message with this 0x8009030c code.

In my case, the user didn't have access to the sql computer from the network and I had a failure audit message indicating that (I think the same message also happens in other cases).

Go to: Local Security Policy -> Security Settings -> Local Policies -> User Rights Assignment -> Access this computer from the network -> add the user

It fixed the problem

blocks|key|1905417|text|这个问题的关键，至少对我来说，是通过环回接口(127.0.0.1)建立到SQL+Server的连接。我有同样的症状，并在this+blog+post中找到了答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1905418|总而言之:发生了环回检查，这会导致通过环回适配器的可信连接失败。可以通过添加注册表项来删除此检查，如下所示：|1905419|1905420|使用regedit编辑注册表。(开始->运行…HKLM\System\CurrentControlSet\Control\LSA|ordered-list-item|1905421|Add+)此值浏览到:将名为“DisableLoopbackCheck”|1905422|Set+|1905423|的DWORD值编辑为1|1905424|1905425|我在进行此更改后重启了系统，只是为了确认一下，但您可能会发现这不是必需的。在此注册表更改生效后，我可以通过环回适配器建立可信连接。|1905426|感谢Blackhawk+Consulting+Blog在这个问题上为我指明了正确的方向。|1905427|entityMap|0|LINK|mutability|MUTABLE|url|http://www.bhcblog.com/2009/10/08/fix-for-login-failed-for-user-the-user-is-not-associated-with-a-trusted-sql-server-connection/|1|http://www.bhcblog.com/^0|1O|E|0|0|0|0|0|0|0|0|0|0|2|P|1|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|19|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|1A|8|@]|9|@]|C|$]]|$1|J|3|K|5|I|7|1B|8|@]|9|@]|C|$]]|$1|L|3|M|5|I|7|1C|8|@]|9|@]|C|$]]|$1|N|3|O|5|I|7|1D|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|1E|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|C|$]]|$1|S|3|T|5|6|7|1G|8|@]|9|@$A|1H|B|1I|1|1J]]|C|$]]|$1|U|3|-4|5|6|7|1K|8|@]|9|@]|C|$]]]|V|$W|$5|X|Y|Z|C|$10|11]]|12|$5|X|Y|Z|C|$10|13]]]]

The key to this issue, for me at least, is the fact that the connection to SQL Server is being made over the loopback interface (127.0.0.1). I had the same symptoms, and found the answer in <a href="http://www.bhcblog.com/2009/10/08/fix-for-login-failed-for-user-the-user-is-not-associated-with-a-trusted-sql-server-connection/">this blog post</a>.

To summarise: there is a loopback check taking place which causes trusted connections via the loopback adapter to fail. This check can be removed by adding a registry entry as follows:

<ol>
<li>Edit the registry using regedit. (start –> run … Regedit )</li>
<li>Browse to : HKLM\System\CurrentControlSet\Control\LSA</li>
<li>Add a DWORD value called “DisableLoopbackCheck”</li>
<li>Set this value to 1</li>
</ol>

I rebooted after making this change, just to be sure, but you may find that this is not necessary. After this registry change was effected, I could make trusted connections via the loopback adapter.

Kudos to the <a href="http://www.bhcblog.com/">Blackhawk Consulting Blog</a> for pointing me in the right direction on this issue.

blocks|key|1905443|text|我也遇到了这个问题，原因很简单:我的域用户的密码已过期，因此凭据已被撤销。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1905444|碰巧的是，我还让SQL+Management+Studio保持打开状态，这样在我更改域密码之前，它每隔2-3分钟就会生成一次这样的错误。|1905445|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I also had this problem, and the cause was simple: my domain user's password had expired, so the credentials had been revoked. 

As it happened, I had also left SQL Management Studio open so it generated errors like these every 2-3 minutes until I changed my domain password.

blocks|key|4015947|text|使用微软的err.exe|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4015948|C:\>err+0x8009030c
#+for+hex+0x8009030c+/+decimal+-2146893044+:
++SEC_E_LOGON_DENIED++++++++++++++++++++++++++++++++++++++++++++winerror.h
#+The+logon+attempt+failed
#+1+matches+found+for+"0x8009030c"|code-block|syntax|javascript|4015949|DC会因为许多不同的原因拒绝登录，包括到DC的间歇性连接失败。|4015950|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Using Microsoft's err.exe

<pre><code>C:\&gt;err 0x8009030c
# for hex 0x8009030c / decimal -2146893044 :
 SEC_E_LOGON_DENIED winerror.h
# The logon attempt failed
# 1 matches found for "0x8009030c"
</code></pre>

A DC will deny a login for many different reasons, including intermittent connectivity failures to a DC.

blocks|key|4015965|text|另一个原因可能是帐户被锁定。这是因为每隔半小时就有一个流氓服务使用错误的密码运行。该帐户是一个服务帐户，并设置为在发生此情况的几分钟后自行解锁，因此很难跟踪。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4015966|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Another cause can be if the account is locked out. We had this due to a rogue service running every half hour with the wrong password. The account was a service account and set to unlock itself after a few minutes where this occurred so it was quite difficult to track down.

I get the following error while trying to connect to SQL Server 2005 using JDBC connection.

<pre><code> Error: 17806, Severity: 20, State: 2.
 Logon SSPI handshake failed with error code 0x8009030c while establishing 
 a connection with integrated security; the connection has been 
 closed. [CLIENT: 127.0.0.1]
 Logon Error: 18452, Severity: 14, State: 1.
 Logon Login failed for user ''. The user is not associated with a trusted 
 SQL Server connection. [CLIENT: 127.0.0.1]
</code></pre>

MY connection URL:

<pre><code>jdbc:sqlserver://LOCALHOST:1433;DatabaseName=master;integratedSecurity=true
</code></pre>

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

尝试使用JDBC连接连接到SQL Server2005时出现以下错误。 Error: 17806, Severity: 20, State: 2. Logon       SSPI handshake failed with error code 0x8009030c while establishing       ...

问使用集成安全性建立连接时，SSPI握手失败，错误代码为0x8009030c
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用集成安全性建立连接时，SSPI握手失败，错误代码为0x8009030cEN