AbleCommerce Shopping Cart Software

Hello all,

Forgive me if this is in the wrong section but here it goes.

I have a development server running IIS7 with Ablecommerce 7.0.5. I have a separate server running SQL 2008 Express. I ran through the install of Ablecommerce and got the development site running. (could view the default pages and menus) The database connection tested successful via ODBC connection. Plus I was able to initialize the database via Ablecommerce when setting up the machine.

Fast forward a couple of months. The project of making our website with Ablecommerce a production website is back on the front burner. Although when I load my test development Merchant Dashboard I am greeted with an ASP error.

Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>


Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration

Pretty blan error page.

Event Viewer gives me ASP error:

Event code 3005
Unhandled Exception has occurred

Exception Information:
Exception type: SqlException
Exception message: Login failed for user 'mydevuser'

-----

On the SQL Express server I reset the user account's password.

On the web server I opened the ODBC connection and tested the connection to the SQL Express server and it was successful.

I restarted both servers.

I am still getting the ASP error on the Merchant page.

I think I am missing something simple.

Any help would be greatly appreciated.

Thanks,

Nick

Log Name: Application
Source: ASP.NET 2.0.50727.0
Date: 8/25/2011 11:21:20 AM
Event ID: 1309
Task Category: Web Event
Level: Warning
Keywords: Classic
User: N/A
Computer: ONYX-WEBDEV
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 8/25/2011 11:21:20 AM
Event time (UTC): 8/25/2011 3:21:20 PM
Event ID: 07068c28c1d44285b9f8f9a959bed5ea
Event sequence: 21
Event occurrence: 11
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT-4-129587584879144567
Trust level: Full
Application Virtual Path: /
Application Path: D:\www\
Machine name: ONYX-WEBDEV

Process information:
Process ID: 3156
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: SqlException
Exception message: Login failed for user 'mydevuser'.

Request information:
Request URL: http://webdev.wilcoxind.com/login.aspx?ReturnUrl=An unhandled exception has occurred.fAdminAn unhandled exception has occurred.fDefault.aspx
Request path: /login.aspx
User host address: 10.10.10.18
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at CommerceBuilder.Data.Database.OpenConnection()
at CommerceBuilder.Data.Database.ExecuteScalar(DbCommand command)
at CommerceBuilder.Configuration.TokenBase.a(Database A_0)
at CommerceBuilder.Configuration.TokenBase.a(HttpApplicationState A_0, HttpRequest A_1, AbleCommerceApplicationSection A_2, Database A_3)
at CommerceBuilder.Configuration.TokenBase..ctor()
at CommerceBuilder.Common.Token..ctor()
at CommerceBuilder.Common.Token.get_Instance()
at CommerceBuilder.Utility.ErrorMessage.Save()
at CommerceBuilder.Utility.Logger.a(String A_0, LogMessageType A_1, Exception A_2, Type A_3)
at ASP.AcApp.Application_Error(Object sender, EventArgs e)
at System.Web.HttpApplication.RaiseOnError()


Custom event details: Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="ASP.NET 2.0.50727.0" />
<EventID Qualifiers="32768">1309</EventID>
<Level>3</Level>
<Task>3</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-08-25T15:21:20.000Z" />
<EventRecordID>5444</EventRecordID>
<Channel>Application</Channel>
<Computer>ONYX-WEBDEV</Computer>
<Security />
</System>
<EventData>
<Data>3005</Data>
<Data>An unhandled exception has occurred.</Data>
<Data>8/25/2011 11:21:20 AM</Data>
<Data>8/25/2011 3:21:20 PM</Data>
<Data>07068c28c1d44285b9f8f9a959bed5ea</Data>
<Data>21</Data>
<Data>11</Data>
<Data>0</Data>
<Data>/LM/W3SVC/1/ROOT-4-129587584879144567</Data>
<Data>Full</Data>
<Data>/</Data>
<Data>D:\www\</Data>
<Data>ONYX-WEBDEV</Data>
<Data>
</Data>
<Data>3156</Data>
<Data>w3wp.exe</Data>
<Data>NT AUTHORITY\NETWORK SERVICE</Data>
<Data>SqlException</Data>
<Data>Login failed for user 'mydevuser'.</Data>
<Data>http://webdev.wilcoxind.com/login.aspx? ... aspx</Data>
<Data>/login.aspx</Data>
<Data>10.10.10.18</Data>
<Data>
</Data>
<Data>False</Data>
<Data>
</Data>
<Data>NT AUTHORITY\NETWORK SERVICE</Data>
<Data>5</Data>
<Data>NT AUTHORITY\NETWORK SERVICE</Data>
<Data>False</Data>
<Data> at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at CommerceBuilder.Data.Database.OpenConnection()
at CommerceBuilder.Data.Database.ExecuteScalar(DbCommand command)
at CommerceBuilder.Configuration.TokenBase.a(Database A_0)
at CommerceBuilder.Configuration.TokenBase.a(HttpApplicationState A_0, HttpRequest A_1, AbleCommerceApplicationSection A_2, Database A_3)
at CommerceBuilder.Configuration.TokenBase..ctor()
at CommerceBuilder.Common.Token..ctor()
at CommerceBuilder.Common.Token.get_Instance()
at CommerceBuilder.Utility.ErrorMessage.Save()
at CommerceBuilder.Utility.Logger.a(String A_0, LogMessageType A_1, Exception A_2, Type A_3)
at ASP.AcApp.Application_Error(Object sender, EventArgs e)
at System.Web.HttpApplication.RaiseOnError()
</Data>
</EventData>
</Event>

Looks like your database is not accessible.