3

I have uploaded my website on IIS 7 Windows Server 2008. Everything works fine. My site also uses database SQL to keep record of users. But when I try to login I get following error. 

 Cannot open database "MyCoolDb" requested by the login. The login failed.
 Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.

 Ausnahmedetails: System.Data.SqlClient.SqlException: Cannot open database   
 "MyCoolDb"     
 requested by the login. The login failed.
 Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.
sqlab
  • 6,412
  • 1
  • 14
  • 29
Wafeeq
  • 869
  • 1
  • 16
  • 34
  • 1
    possible duplicate of [Login failed for user 'IIS APPPOOL\ASP.NET v4.0'](http://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0) – jean Feb 17 '14 at 13:58
  • @jean: Problem is solved by the link you refered. – Wafeeq Feb 18 '14 at 15:29
  • Related: http://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0 – GibboK May 03 '15 at 18:31

2 Answers2

4

You can add this user to your DB Logins by openning SQL Management Studio, Navigate to your database then open the Security then Logings and add new login and search for that user

Haitham Shaddad
  • 4,336
  • 2
  • 14
  • 19
1

with refrence to this Link: Login failed for user 'IIS APPPOOL\ASP.NET v4.0'

you need to add IIS APPPOOL\ASP.NET v4.0 as it is in the Login on SQL Server Management Studio

Community
  • 1
  • 1
Muhammad Omar ElShourbagy
  • 6,718
  • 2
  • 32
  • 50