SQL Server登录错误：用户'NT AUTHORITY \SYSTEM'登录失败 [英] SQL Server Login error: Login failed for user 'NT AUTHORITY\SYSTEM'

问题描述

我创建了一个名为schoolPool的应用程序池，并将其分配给我的Web应用程序。此池的标识已设置为LocalSystem。
当我尝试从应用程序中访问我的数据库时，即打开SQL连接时，我始终收到以下错误：

I have created an application pool called "schoolPool" and assigned it to my web application. Identity for this pool has been set to LocalSystem. When I try to access my database from within the application, i.e. open a SQL connection, I get the following error all the time:

Login failed for user 'NT AUTHORITY\SYSTEM'

我尝试将NT AUTHORITY / SYSTEM添加到SSMS（SQL Server Management Studio）登录，但它已经是主体，显示以下错误：

< img src =https://i.stack.imgur.com/gQEQ1.pngalt =在此处输入图像说明>

I tried to add NT AUTHORITY/SYSTEM to SSMS (SQL Server Management Studio) logins, but it was already a principal, showing the following error:

推荐答案

我大量调整了应用程序设置，将应用程序池的标识（在Windows 8.1的IIS中）更改为LocalSystem，LocalService，NetworkService和ApplicationPoolIdentity。但是，所有这些都无法解决我登录数据库的问题。


最后我在LocalSystem上设置了池身份，并想到为什么它可能阻止NT AUTHRITY \ SYSTEM打开与我的数据库的连接。我以管理员用户身份打开了SQL Server Management Studio，并在登录部分下检查了服务器角色中的NT AUTHORITY \ SYSTEM。默认情况下，此用户的默认服务器角色为 public 。 我还检查了sysadmin 并刷新了我的网络申请表。这次是成功的。干得好！

I tweaked the application settings a lot, changing the application pool's identity (in Windows 8.1's IIS) to LocalSystem, LocalService, NetworkService, and ApplicationPoolIdentity. However, all of them failed to solve the problem I had logging into my database.
Finally I set the pool identity on LocalSystem and thought why it might be preventing "NT AUTHRITY\SYSTEM" from opening a connection to my database. I opened up SQL Server Management Studio as the user "Administrator" and checked out the Server Roles for NT AUTHORITY\SYSTEM under "logins" section. The default server role for this user was public by default. I also checked sysadmin and refreshed my web application form. This time it was a success. Great job!

这篇关于SQL Server登录错误：用户'NT AUTHORITY \SYSTEM'登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！