不断收到＆QUOT;用户登录失败IIS APPPOOL \\默认应用＆QUOT;不管我做什么 [英] Keep getting "Login failed for user IIS APPPOOL\DefaultAppPool" no matter what I do
问题描述
我想举一个ASP NET应用程序访问数据库（这些测试不仅没有生产）。
I'm trying to give an ASP NET App access to a database (These are test only not production).
这是我第一次尝试，在这个网络中，而我还没有VS2012做这件事，SQL Server 2012的前preSS，Windows 7的前
It's the first time I try it in this network, and I haven't done it with VS2012, SQL Server 2012 Express, Windows 7 before
我做了什么：
- 我升级我的SQL Server 2012前preSS 因为什么VS2012首先安装一个版本不允许从IIS访问
- 我发现我不得不配置SQL Server 2012前preSS接受的远程连接，然后我跟着一个好的博客，我发现的这里
- 在2012 SSME，我添加了一个新的登录所有数据库的 NT AUTHORITY \\ NETWORKSERVICE （我浏览了一下，发现SERVICIO德红它代表NETWORKSERVICE，因此它实际上就是 NT AUTHORITY \\ SERVICIO德红）
- 我设置DBO作为默认模式为这个登录
- 在登录属性，在用户映射后，我检查了我的数据库（我叫MiniNorthwind），然后检查了数据库角色成员具有db_datareader和db_datawriter为MiniNorthwind
- 在Internet信息服务管理器我检查了默认应用身份的 ApplicationPoolIdentity （这是默认设置）
- I upgraded my Sql Server 2012 Express since what VS2012 first installs is a version that doesn't allow access from IIS
- I found that I had to configure SQL Server 2012 Express to accept remote connections, then I followed a good blog I found here
- In SSME 2012, I added a new login for all databases NT AUTHORITY\NETWORKSERVICE (I browsed it and found "Servicio de red" which stands for NETWORKSERVICE, so it is actually NT AUTHORITY\Servicio de red)
- I set dbo as the default schema for this login
- Under login properties, in User Mappings, I checked my Database (which I named MiniNorthwind) and then checked db_datareader and db_datawriter in Database Role Membership for MiniNorthwind
- In Internet Information Services Manager I checked that the DefaultAppPool Identity was ApplicationPoolIdentity (It was the default setting)
但我仍然得到一个错误，指出用户登录失败IIS APPPOOL \\默认应用后，如果我更改了默认应用身份网络服务，那么误差变化为登录失败，用户NT AUTHORITY \\ SERVICIO德红
But I still get an error saying that Login failed for user IIS APPPOOL\DefaultAppPool, if I change the DefaultAppPool identity to NetworkService, then the error changes to Login failed for user NT AUTHORITY\Servicio de red
我不知道自己还能做什么。拜托，这里需要帮助。
I don't know what else to do. Please, need help here.
拉斐尔
推荐答案
在IIS管理器中设置默认应用的身份为网络服务。虽然它的工作原理，你应该尽量做到与AppPoolIdentity工作，因为Windows 7的尝试，使之更加安全。
In IIS Manager set DefaultAppPool identity as NetworkService. Although it works, you should try to make it work with AppPoolIdentity, since it the Windows 7 attempt to make it safer
这篇关于不断收到＆QUOT;用户登录失败IIS APPPOOL \\默认应用＆QUOT;不管我做什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
