none
[SqlException (0x80131904): Login failed for user 'IIS APPPOOL\DefaultAppPool'.] RRS feed

  • Question

  • Hello,

    I am getting following error while openning connection with Database from asp.net application.

    [SqlException (0x80131904): Login failed for user 'IIS APPPOOL\DefaultAppPool'.]

    Here on the database I have windows authentication and connection string in web.config is set accordingly and given below:

    Data Source=.;Initial Catalog=<DB Name>;Integrated Security=true;Persist Security Info=False;" providerName="System.Data.SqlClient"

    In IIS:

    I have a website which is using "DefaultAppPool" and this app pool is running under the identity of "ApplicationPoolIdentity".

    Please help me out.

    Regards,

    Hari Mohan


    Hari

    Tuesday, May 12, 2015 12:29 PM

Answers

  • They'll help you over here.

    http://forums.asp.net/

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Wednesday, May 13, 2015 9:39 AM
    Moderator

All replies

  • Hello Hari, Do you have this user setup as a user on your SQL Database? Under SSMS expand the security right click on logins and select "New Login". In the New Login dialog, enter the app pool(IIS APPPOOL\DefaultAppPool) as the login name and click "OK". You can then right click the login for the app pool, select Properties and select "User Mapping". Check the appropriate database, and the appropriate roles. Hope this helps!
    Wednesday, May 13, 2015 3:10 AM
  • They'll help you over here.

    http://forums.asp.net/

     

     

     


    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows]

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

    Wednesday, May 13, 2015 9:39 AM
    Moderator