无法打开数据库“HRPaidTimeOff”登录请求。登录失败。用户'IIS APPPOOL \DefaultAppPool登录失败 [英] Cannot open database "HRPaidTimeOff" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\DefaultAppPool

问题描述

在运行项目时，我收到以下错误..



无法打开数据库HRPaidTimeOff登录请求。登录失败。

用户'IIS APPPOOL \DefaultAppPool'登录失败。



描述：执行期间发生未处理的异常当前的网络请求。请查看堆栈跟踪以获取有关错误及其在代码中的起源的更多信息。



异常详细信息：System.Data.SqlClient.SqlException：无法打开数据库 ; HRPaidTimeOff"登录请求。登录失败。

用户'IIS APPPOOL \DefaultAppPool'登录失败。



来源错误：





第518行：公共ISingleResult< ENTCapability> ENTCapabilitySelectAll（）

第519行：{

第520行：IExecuteResult结果= this.ExecuteMethodCall（this，（（MethodInfo）（MethodInfo.GetCurrentMethod（）））;;

第521行：return（（ISingleResult< ENTCapability>）（result.ReturnValue））;

第522行：}





源文件：F：\DotNetProjects \ PaidTimeOffSolution-vinay \ PaidTimeOffSolution\V2.PaidTimeOffDAL\HRPaidTimeOff.designer.cs行：520





请问如何删除上述错误...

While running an project i am getting an following error..

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "HRPaidTimeOff" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.

Source Error:


Line 518: public ISingleResult<ENTCapability> ENTCapabilitySelectAll()
Line 519: {
Line 520: IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
Line 521: return ((ISingleResult<ENTCapability>)(result.ReturnValue));
Line 522: }


Source File: F:\DotNetProjects\PaidTimeOffSolution-vinay\PaidTimeOffSolution\V2.PaidTimeOffDAL\HRPaidTimeOff.designer.cs Line: 520


Please how would i remove the above error...

推荐答案

您需要添加用户IIS APPPOOL \DefaultAppPool到数据库的安全设置。



查看此文章。 [ ^ ]

You need to add the user IIS APPPOOL\DefaultAppPool to the security setup of the database.

See this article.[^]

这篇关于无法打开数据库“HRPaidTimeOff”登录请求。登录失败。用户'IIS APPPOOL \DefaultAppPool登录失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！