如何为IIS App Pool帐户授予数据库权限? [英] How can I Grant permissions to a database for the IIS App Pool account?

问题描述

如何授予从IIS登录和访问AdventureWorks数据库的权限?

How can I grant permissions to log in and access the AdventureWorks database from the IIS?

我正在Visual Studio 2010(IIS中托管的Silverlight)中开发应用程序，但出现错误消息，因为用户IIS APPPOOL \ ASP .NET 4.0登录失败，它无法打开AdventureWorks数据库.

I'm developing an application in Visual Studio 2010 (Silverlight hosted in the IIS) and I get an error saying that it couldn't open the AdventureWorks database since login failed for user IIS APPPOOL\ASP .NET 4.0.

推荐答案

使用SQL Server Management Studio.

Use SQL Server Management Studio.

1. 在SQL Server中为IIS AppPool \ {YourApplicationPoolName}创建Windows登录
2. 将此登录名添加到您的数据库
3. 根据需要授予数据库中帐户的权限.

这篇关于如何为IIS App Pool帐户授予数据库权限?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！