EXTRANET ECTS EVENT ID 1309 ASP.NET 2.0.50727.0 ERROR

Topics: Internet/Extranet Edition
Jul 17, 2008 at 10:29 PM
I am unable to use the Configuration Utility Web Part to setup ECTS  I receive the following error

Server Error in '/' Application.
--------------------------------------------------------------------------------

ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
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.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

Source Error:

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. 

Stack Trace:

[InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.]
   System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) +925120
   System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +9
   System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +99
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +75
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
   EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue, String Name, String Value) +521
   EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue) +17
   EAT.ConfigurationUtility.ConfigurationUtility.UpdateDB_Click(Object sender, EventArgs e) +117
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

 --------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

I also receive an error in the event logs 

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  7/17/2008
Time:  1:08:28 PM
User:  N/A
Computer: FS70CLBEXNET
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/17/2008 1:08:28 PM
Event time (UTC): 7/17/2008 5:08:28 PM
Event ID: 4c88380d89a142d581e5302d0019039c
Event sequence: 3
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1544875940/Root-1-128607881000699123
    Trust level: WSS_Minimal
    Application Virtual Path: /
    Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\extranet80\
    Machine name: FS70CLBEXNET
 
Process information:
    Process ID: 2808
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: InvalidOperationException
    Exception message: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
 
Request information:
    Request URL: http://extranet/default.aspx
    Request path: /default.aspx
    User host address: 10.1.3.180
    User: FORTUNOFF\jlucivero
    Is authenticated: True
    Authentication Type: NTLM
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue, String Name, String Value)
   at EAT.Common.SqlManager.SetEntry(String DbName, String Column, String SetValue)
   at EAT.ConfigurationUtility.ConfigurationUtility.UpdateDB_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Anyone ever come across this? Thank you in advance