用户登录失败'IIS APPPOOL \\ myAppPool [英] Login failed for user 'IIS APPPOOL\myAppPool

问题描述

我有以下错误信息：

无法打开数据库SmallBakery所要求的登录。登录失败。用户登录失败'IIS APPPOOL \\ MyAppPool

Cannot open database "SmallBakery" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\MyAppPool'

该如何纠正呢？我使用Windows 7企业版和SQL Server 2012中。

How can correct this? I am using windows 7 Enterprise Edition and Sql server 2012.

推荐答案

如果你不改变，每个应用程序池都有它自己的身份。对你来说，只是一个新的用户添加到您的数据库 SmallBakery 使用SQL Management Studio中的名称 IIS APPPOOL \\ MyAppPool 。你会发现在你的数据库的安全/用户子节点的用户列表。这应该是这个样子的：

If you don't change, each app pool has it's own identity. In your case, just add a new user to your database SmallBakery with the name IIS APPPOOL\MyAppPool using SQL Management Studio. You find the users list in the "Security/Users" subnode of your database. This should look something like that:

有关测试，让用户成为的db_owner 角色的成员。如果这样的作品，删除这个角色，只是让它成为成员的db_datareader 和 db_datawriter权限。

For testing, let the user be member of the db_owner role. If that works, remove this role and just let it be member of db_datareader and db_datawriter.

这样，每一个应用程序池（也许每个网站，如果他们都使用自己的应用程序池）只能访问到相应的数据库。

This way, each app pool (perhaps each website, if they all use their own app pool) only has access to the corresponding database.

这篇关于用户登录失败'IIS APPPOOL \\ myAppPool的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！