Mike,
This can be a problem with the connection pool running out of
connections because they are not being re-cycled, or with a lock in
the database that is being held.

Take a look at the processes on SQL Server and see if there are any blocking.

Try stopping and re-starting the WWW service and see if that clears the error.  

Go through your code and make sure you are closing all your connections cleanly.

On 7/18/05, Mike Belcher
<[EMAIL PROTECTED]> wrote:
> Okay all this used to be fine on another machine it has just been moved.
> 
> 
> Original machine
> Windows 2003 server 32bit
> .Net 2.0
> Sql server 2005
> 
> 
> 
> New machine
> Windows 2003 server 64bit
> .Net 2.0
> Sql server 2005
> 
> 
> 
>  I don't see how this is a timeout setting issue as it shouldn't take but a
> second to access what it needs. It also works  fine on the original machine
> which is still up. I go to the website and try to login and get that error
> message. Says it timed out or server is not responding. Below are the
> details.
> 
> 
> HERE IS THE ERROR IN EVENT VIEWER
> ____________________________________________________
> 
> Event code: 3005
> 
> Event message: An unhandled exception has occurred.
> 
> Event time: 7/17/2005 3:26:38 AM
> 
> Event time (UTC): 7/17/2005 7:26:38 AM
> 
> Event ID: 1da418026f5641e8914bcafa571233c3
> 
> Event sequence: 10
> 
> Event occurrence: 1
> 
> Event detail code: 0
> 
> 
> 
> Application information:
> 
>     Application domain: /LM/W3SVC/1/Root/application1-127660587297031250
> 
>     Trust level: Full
> 
>     Application Virtual Path: /application
> 
>     Application Path: D:\Websites\application\
> 
>     Machine name: DATING
> 
> 
> 
> Process information:
> 
>     Process ID: 3892
> 
>     Process name: w3wp.exe
> 
>     Account name: NT AUTHORITY\NETWORK SERVICE
> 
> 
> 
> Exception information:
> 
>     Exception type: SqlException
> 
>     Exception message: Timeout expired.  The timeout period elapsed prior to
> completion of the operation or the server is not responding.
> 
> 
> 
> Request information:
> 
>     Request URL: http://dating/application/Login.aspx
> 
>     Request path: /application/Login.aspx
> 
>     User host address: 192.168.1.20
> 
>     User:
> 
>     Is authenticated: False
> 
>     Authentication Type:
> 
>     Thread account name: NT AUTHORITY\NETWORK SERVICE
> 
> 
> 
> Thread information:
> 
>     Thread ID: 7
> 
>     Thread account name: NT AUTHORITY\NETWORK SERVICE
> 
>     Is impersonating: False
> 
>     Stack trace:    at
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
> Boolean breakConnection)
> 
>    at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
> t stateObj)
> 
>    at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
> Boolean& failoverDemandDone, String host, String failoverPartner, String
> protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean
> encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean
> aliasLookup)
> 
>    at
> System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
> owningObject, SqlConnectionString connectionOptions, String newPassword,
> Boolean redirectedUserInstance)
> 
>    at
> System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString
> connectionOptions, Object providerInfo, String newPassword, SqlConnection
> owningObject, Boolean redirectedUserInstance)
> 
>    at
> System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpti
> ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
> DbConnection owningConnection)
> 
>    at
> System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnec
> tion owningConnection, DbConnectionPool pool, DbConnectionOptions options)
> 
>    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> owningObject)
> 
>    at
> System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
> owningObject)
> 
>    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 citimatch.Login.LoginButton_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.RaisePo
> stBackEvent(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.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> HERE IS THE ERROR IN INTERNET EXPLORER
> ____________________________________________________
> Server Error in '/APPlication' Application.
> 
> 
> 
>   _____
> 
> 
> 
> Timeout expired.  The timeout period elapsed prior to completion of the
> operation or the server is not responding.
> 
> 
> 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: Timeout expired.  The
> timeout period elapsed prior to completion of the operation or the server is
> not responding.
> 
> 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:
> 
> 
> 
> [SqlException (0x80131904): Timeout expired.  The timeout period elapsed
> prior to completion of the operation or the server is not responding.]
>    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection) +684931
> 
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
> t stateObj) +207
>    System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
> Boolean& failoverDemandDone, String host, String failoverPartner, String
> protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean
> encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean
> aliasLookup) +890
> 
> System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
> owningObject, SqlConnectionString connectionOptions, String newPassword,
> Boolean redirectedUserInstance) +601
>    System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString
> connectionOptions, Object providerInfo, String newPassword, SqlConnection
> owningObject, Boolean redirectedUserInstance) +159
> 
> System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpti
> ons options, Object poolGroupProviderInfo, DbConnectionPool pool,
> DbConnection owningConnection) +346
> 
> System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnec
> tion owningConnection, DbConnectionPool pool, DbConnectionOptions options)
> +28
>    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> owningObject) +445
>    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
> owningObject) +66
>    System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
> owningObject) +304
>    System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
> owningConnection) +85
>    System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
> outerConnection, DbConnectionFactory connectionFactory) +105
>    System.Data.SqlClient.SqlConnection.Open() +111
>    citimatch.Login.LoginButton_Click(Object sender, EventArgs e) +576
>    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
>    System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
> +78
> 
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
> stBackEvent(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) +5670
> 
> 
> 
>   _____
> 
> Version Information: Microsoft .NET Framework Version:2.0.50215.44; ASP.NET
> Version:2.0.50215.44
> 
> 
> 
> 
> 
> 
> 
> 
> 
> [Non-text portions of this message have been removed]
> 
> 
> 
> 
> Yahoo! Groups Links
> 
> 
> 
> 
> 
> 
> 


-- 
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com


 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to