an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Database connectivity issue
Last Post 2/15/2011 5:58:37 PM By lukezy. 1 replies.
2/15/2011 5:02:59 PM
haroonsher
Posts: 2
Joined: 2/12/2011
Database connectivity issue
Please help
 
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: Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.

Source Error:

 
<table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td>An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</td> </tr> </tbody> </table>
Stack Trace:

<table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td>
[SqlException (0x80131904): Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +690
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +89
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6296606
   System.Data.SqlClient.SqlConnection.Open() +300
   Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection() +274
   Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection(Boolean disposeInnerConnection) +73
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command) +55
   Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database) +132
   Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues) +135
   DotShoppingCart.OpenSource.Core.DbFileBase.GetTimeStamp(String host, Object key, Boolean enableSqlDep, SqlCacheDependency& dep) +144
   DotShoppingCart.OpenSource.Core.DbFileBase.GetFile(String host, Object key, Boolean enableSqlDep) +190
   DotShoppingCart.OpenSource.Core.BasePage.OnPreInit(EventArgs e) +864
   System.Web.UI.Page.PerformPreInit() +49
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1700
</td> </tr> </tbody> </table>
 
2/15/2011 5:58:37 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Database connectivity issue
You need to configure the application pool to use "Network Service" identity via Advanced Settings -> Process Model -> Identity select Built-in account "NetworkService".
DotShoppingCart Staff