+1-888-365-2779
Try Now
More in this section

Forums / Deployment / Telerik.OpenAccess.RT.sql.SQLException: Login failed for user 'IIS APPPOOL\ASP.NET 4.0'.

Telerik.OpenAccess.RT.sql.SQLException: Login failed for user 'IIS APPPOOL\ASP.NET 4.0'.

4 posts, 0 answered
  1. Yan
    Yan avatar
    10 posts
    Registered:
    24 Jul 2012
    08 Aug 2012
    Link to this post
    [SQLException: Login failed for user 'IIS APPPOOL\ASP.NET 4.0'.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps, ConnectionPoolType poolType, LogEventStore pes) +684
       OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType) +273

    I have granted modify permission to user 'IIS APPPOOL\ASP.NET 4.0'. What is wrong with this? Thanks a lot!!
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    09 Aug 2012
    Link to this post
    Hello,

    This user doesn't belong a SQL Server role that has permissions to create/read your database. You need to add a login to SQL Server for IIS APPPOOL\ASP.NET v4.0 and grant permissions to the database you want to use. If you are installing Sitefinity you need CREATE DATABASE permission.

    Greetings,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Yan
    Yan avatar
    10 posts
    Registered:
    24 Jul 2012
    14 Aug 2012
    Link to this post
    Yes. That solves problem. Thanks!
  4. Anjan
    Anjan avatar
    1 posts
    Registered:
    20 Sep 2013
    26 Dec 2013
    Link to this post
    Hello,
    I have faced this issue in windows 7, pop up me error "Login failed for user IIS apppool default apppool" then I start look into IIS application, 
    1. I check "Identity" under process model in "Advance Settings" and change in account to "Local system" then it works fine me. 

    I suggest to check following link  http://www.technologycrowds.com/2013/03/login-failed-for-user-iis.html#.UrwLQNIW3Yd to solve error Login failed for user IIS apppool default apppool
4 posts, 0 answered