Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Urgent: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Reply
Thread Tools

Urgent: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

 
 
VB Programmer
Guest
Posts: n/a
 
      01-16-2006
When I run my ASP.NET 2.0 web app on my dev machine it works perfect. When
I precomile it to my web deployment project and then copy the debug files to
my web server I get this problem when trying to login (obviously it's using
ASPNETDB.mdf). Any ideas?



Server Error in '/' 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.OnErro r(SqlException
exception, Boolean breakConnection) +684835
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
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.Ope nLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance) +601
System.Data.SqlClient.SqlInternalConnectionTds..ct or(SqlConnectionString
connectionOptions, Object providerInfo, String newPassword, SqlConnection
owningObject, Boolean redirectedUserInstance) +159
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) +108
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
owningObject) +445
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject) +304
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context,
Boolean revertImpersonate) +126
System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String
connectionString, Boolean revertImpersonation) +239
System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String
username, Int32& status, String& password, Int32& passwordFormat, String&
passwordSalt, Int32& failedPasswordAttemptCount, Int32&
failedPasswordAnswerAttemptCount, Boolean& isApproved) +815
System.Web.Security.SqlMembershipProvider.CheckPas sword(String username,
String password, Boolean updateLastLoginActivityDate, Boolean
failIfNotApproved, String& salt, Int32& passwordFormat) +80
System.Web.Security.SqlMembershipProvider.CheckPas sword(String username,
String password, Boolean updateLastLoginActivityDate, Boolean
failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.Validate User(String username,
String password) +78
System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs e)
+161
System.Web.UI.WebControls.Login.AttemptLogin() +94
System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e)
+101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument)
+134
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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


 
Reply With Quote
 
 
 
 
john smith
Guest
Posts: n/a
 
      01-16-2006
VB Programmer wrote:
> When I run my ASP.NET 2.0 web app on my dev machine it works perfect. When
> I precomile it to my web deployment project and then copy the debug files to
> my web server I get this problem when trying to login (obviously it's using
> ASPNETDB.mdf). Any ideas?
>
>
>
> Server Error in '/' 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.OnErro r(SqlException
> exception, Boolean breakConnection) +684835
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> 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.Ope nLoginEnlist(SqlConnection
> owningObject, SqlConnectionString connectionOptions, String newPassword,
> Boolean redirectedUserInstance) +601
> System.Data.SqlClient.SqlInternalConnectionTds..ct or(SqlConnectionString
> connectionOptions, Object providerInfo, String newPassword, SqlConnection
> owningObject, Boolean redirectedUserInstance) +159
> System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
> options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
> owningConnection) +108
> System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
> owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
> System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
> owningObject) +445
> System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
> owningObject) +66
> System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
> owningObject) +304
> System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
> owningConnection) +85
> System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
> outerConnection, DbConnectionFactory connectionFactory) +105
> System.Data.SqlClient.SqlConnection.Open() +111
> System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context,
> Boolean revertImpersonate) +126
> System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String
> connectionString, Boolean revertImpersonation) +239
> System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String
> username, Int32& status, String& password, Int32& passwordFormat, String&
> passwordSalt, Int32& failedPasswordAttemptCount, Int32&
> failedPasswordAnswerAttemptCount, Boolean& isApproved) +815
> System.Web.Security.SqlMembershipProvider.CheckPas sword(String username,
> String password, Boolean updateLastLoginActivityDate, Boolean
> failIfNotApproved, String& salt, Int32& passwordFormat) +80
> System.Web.Security.SqlMembershipProvider.CheckPas sword(String username,
> String password, Boolean updateLastLoginActivityDate, Boolean
> failIfNotApproved) +42
> System.Web.Security.SqlMembershipProvider.Validate User(String username,
> String password) +78
> System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs e)
> +161
> System.Web.UI.WebControls.Login.AttemptLogin() +94
> System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs e)
> +101
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
> System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
> System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument)
> +134
> System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
> eventArgument) +7
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
> sourceControl, String eventArgument) +11
> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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
>
>

Sounds like it can't connect to the database. Are you sure it has
connectivity, that the server is up and running fine, and that the
connection string/configuration is good and all?
 
Reply With Quote
 
 
 
 
VB Programmer
Guest
Posts: n/a
 
      01-16-2006
The webserver is up and running because I have several sites running on
there.

Here is my connectionstring...
<connectionStrings>
<add name="MyMainDatabase" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ASPNETDB.MDF;Integrated
Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

It's the same as on my dev machine which works perfectly. Any idea?
Thanks!

"john smith" <> wrote in message
news:%...
> VB Programmer wrote:
>> When I run my ASP.NET 2.0 web app on my dev machine it works perfect.
>> When I precomile it to my web deployment project and then copy the debug
>> files to my web server I get this problem when trying to login (obviously
>> it's using ASPNETDB.mdf). Any ideas?
>>
>>
>>
>> Server Error in '/' 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.OnErro r(SqlException
>> exception, Boolean breakConnection) +684835
>>
>> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
>> 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.Ope nLoginEnlist(SqlConnection
>> owningObject, SqlConnectionString connectionOptions, String newPassword,
>> Boolean redirectedUserInstance) +601
>>
>> System.Data.SqlClient.SqlInternalConnectionTds..ct or(SqlConnectionString
>> connectionOptions, Object providerInfo, String newPassword, SqlConnection
>> owningObject, Boolean redirectedUserInstance) +159
>>
>> System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
>> options, Object poolGroupProviderInfo, DbConnectionPool pool,
>> DbConnection owningConnection) +108
>>
>> System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
>> owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
>> System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
>> owningObject) +445
>>
>> System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
>> owningObject) +66
>> System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
>> owningObject) +304
>>
>> System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
>> owningConnection) +85
>>
>> System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
>> outerConnection, DbConnectionFactory connectionFactory) +105
>> System.Data.SqlClient.SqlConnection.Open() +111
>> System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context,
>> Boolean revertImpersonate) +126
>> System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String
>> connectionString, Boolean revertImpersonation) +239
>> System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String
>> username, Int32& status, String& password, Int32& passwordFormat, String&
>> passwordSalt, Int32& failedPasswordAttemptCount, Int32&
>> failedPasswordAnswerAttemptCount, Boolean& isApproved) +815
>> System.Web.Security.SqlMembershipProvider.CheckPas sword(String
>> username, String password, Boolean updateLastLoginActivityDate, Boolean
>> failIfNotApproved, String& salt, Int32& passwordFormat) +80
>> System.Web.Security.SqlMembershipProvider.CheckPas sword(String
>> username, String password, Boolean updateLastLoginActivityDate, Boolean
>> failIfNotApproved) +42
>> System.Web.Security.SqlMembershipProvider.Validate User(String
>> username, String password) +78
>> System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs
>> e) +161
>> System.Web.UI.WebControls.Login.AttemptLogin() +94
>> System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source, EventArgs
>> e) +101
>> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
>> +35
>> System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
>> System.Web.UI.WebControls.Button.RaisePostBackEven t(String
>> eventArgument) +134
>>
>> System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
>> eventArgument) +7
>> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
>> sourceControl, String eventArgument) +11
>> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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
>>
>>

> Sounds like it can't connect to the database. Are you sure it has
> connectivity, that the server is up and running fine, and that the
> connection string/configuration is good and all?



 
Reply With Quote
 
VB Programmer
Guest
Posts: n/a
 
      01-16-2006
My hosting company states that they do not support SQL Express, but they
said they would setup a SQL 2005 database.

Does this make sense? What do they need to install for me to use the SQL
Express MDF?

"VB Programmer" <> wrote in message
news:%...
> The webserver is up and running because I have several sites running on
> there.
>
> Here is my connectionstring...
> <connectionStrings>
> <add name="MyMainDatabase" connectionString="Data
> Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ASPNETDB.MDF;Integrated
> Security=True;User Instance=True"
> providerName="System.Data.SqlClient" />
> </connectionStrings>
>
> It's the same as on my dev machine which works perfectly. Any idea?
> Thanks!
>
> "john smith" <> wrote in message
> news:%...
>> VB Programmer wrote:
>>> When I run my ASP.NET 2.0 web app on my dev machine it works perfect.
>>> When I precomile it to my web deployment project and then copy the debug
>>> files to my web server I get this problem when trying to login
>>> (obviously it's using ASPNETDB.mdf). Any ideas?
>>>
>>>
>>>
>>> Server Error in '/' 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.OnErro r(SqlException
>>> exception, Boolean breakConnection) +684835
>>>
>>> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
>>> 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.Ope nLoginEnlist(SqlConnection
>>> owningObject, SqlConnectionString connectionOptions, String newPassword,
>>> Boolean redirectedUserInstance) +601
>>>
>>> System.Data.SqlClient.SqlInternalConnectionTds..ct or(SqlConnectionString
>>> connectionOptions, Object providerInfo, String newPassword,
>>> SqlConnection owningObject, Boolean redirectedUserInstance) +159
>>>
>>> System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
>>> options, Object poolGroupProviderInfo, DbConnectionPool pool,
>>> DbConnection owningConnection) +108
>>>
>>> System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
>>> owningConnection, DbConnectionPool pool, DbConnectionOptions options)
>>> +28
>>> System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
>>> owningObject) +445
>>>
>>> System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
>>> owningObject) +66
>>> System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
>>> owningObject) +304
>>>
>>> System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
>>> owningConnection) +85
>>>
>>> System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
>>> outerConnection, DbConnectionFactory connectionFactory) +105
>>> System.Data.SqlClient.SqlConnection.Open() +111
>>> System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context,
>>> Boolean revertImpersonate) +126
>>> System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String
>>> connectionString, Boolean revertImpersonation) +239
>>>
>>> System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String
>>> username, Int32& status, String& password, Int32& passwordFormat,
>>> String& passwordSalt, Int32& failedPasswordAttemptCount, Int32&
>>> failedPasswordAnswerAttemptCount, Boolean& isApproved) +815
>>> System.Web.Security.SqlMembershipProvider.CheckPas sword(String
>>> username, String password, Boolean updateLastLoginActivityDate, Boolean
>>> failIfNotApproved, String& salt, Int32& passwordFormat) +80
>>> System.Web.Security.SqlMembershipProvider.CheckPas sword(String
>>> username, String password, Boolean updateLastLoginActivityDate, Boolean
>>> failIfNotApproved) +42
>>> System.Web.Security.SqlMembershipProvider.Validate User(String
>>> username, String password) +78
>>> System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs
>>> e) +161
>>> System.Web.UI.WebControls.Login.AttemptLogin() +94
>>> System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source,
>>> EventArgs e) +101
>>> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
>>> +35
>>> System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
>>> System.Web.UI.WebControls.Button.RaisePostBackEven t(String
>>> eventArgument) +134
>>>
>>> System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
>>> eventArgument) +7
>>> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
>>> sourceControl, String eventArgument) +11
>>> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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
>>>
>>>

>> Sounds like it can't connect to the database. Are you sure it has
>> connectivity, that the server is up and running fine, and that the
>> connection string/configuration is good and all?

>
>



 
Reply With Quote
 
bunty
Guest
Posts: n/a
 
      01-24-2006
hi!
add "connection timeout=60;" where 60 is time in minutes. add this
string in connection string of sqlcommand (ado.net)

bunty



//-----------------------------------------------
VB Programmer wrote:

> My hosting company states that they do not support SQL Express, but they
> said they would setup a SQL 2005 database.
>
> Does this make sense? What do they need to install for me to use the SQL
> Express MDF?
>
> "VB Programmer" <> wrote in message
> news:%...
> > The webserver is up and running because I have several sites running on
> > there.
> >
> > Here is my connectionstring...
> > <connectionStrings>
> > <add name="MyMainDatabase" connectionString="Data
> > Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ASPNETDB.MDF;Integrated
> > Security=True;User Instance=True"
> > providerName="System.Data.SqlClient" />
> > </connectionStrings>
> >
> > It's the same as on my dev machine which works perfectly. Any idea?
> > Thanks!
> >
> > "john smith" <> wrote in message
> > news:%...
> >> VB Programmer wrote:
> >>> When I run my ASP.NET 2.0 web app on my dev machine it works perfect.
> >>> When I precomile it to my web deployment project and then copy the debug
> >>> files to my web server I get this problem when trying to login
> >>> (obviously it's using ASPNETDB.mdf). Any ideas?
> >>>
> >>>
> >>>
> >>> Server Error in '/' 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.OnErro r(SqlException
> >>> exception, Boolean breakConnection) +684835
> >>>
> >>> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> >>> 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.Ope nLoginEnlist(SqlConnection
> >>> owningObject, SqlConnectionString connectionOptions, String newPassword,
> >>> Boolean redirectedUserInstance) +601
> >>>
> >>> System.Data.SqlClient.SqlInternalConnectionTds..ct or(SqlConnectionString
> >>> connectionOptions, Object providerInfo, String newPassword,
> >>> SqlConnection owningObject, Boolean redirectedUserInstance) +159
> >>>
> >>> System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
> >>> options, Object poolGroupProviderInfo, DbConnectionPool pool,
> >>> DbConnection owningConnection) +108
> >>>
> >>> System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
> >>> owningConnection, DbConnectionPool pool, DbConnectionOptions options)
> >>> +28
> >>> System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
> >>> owningObject) +445
> >>>
> >>> System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
> >>> owningObject) +66
> >>> System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
> >>> owningObject) +304
> >>>
> >>> System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
> >>> owningConnection) +85
> >>>
> >>> System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
> >>> outerConnection, DbConnectionFactory connectionFactory) +105
> >>> System.Data.SqlClient.SqlConnection.Open() +111
> >>> System.Web.DataAccess.SqlConnectionHolder.Open(Htt pContext context,
> >>> Boolean revertImpersonate) +126
> >>> System.Web.DataAccess.SqlConnectionHelper.GetConne ction(String
> >>> connectionString, Boolean revertImpersonation) +239
> >>>
> >>> System.Web.Security.SqlMembershipProvider.GetPassw ordWithFormat(String
> >>> username, Int32& status, String& password, Int32& passwordFormat,
> >>> String& passwordSalt, Int32& failedPasswordAttemptCount, Int32&
> >>> failedPasswordAnswerAttemptCount, Boolean& isApproved) +815
> >>> System.Web.Security.SqlMembershipProvider.CheckPas sword(String
> >>> username, String password, Boolean updateLastLoginActivityDate, Boolean
> >>> failIfNotApproved, String& salt, Int32& passwordFormat) +80
> >>> System.Web.Security.SqlMembershipProvider.CheckPas sword(String
> >>> username, String password, Boolean updateLastLoginActivityDate, Boolean
> >>> failIfNotApproved) +42
> >>> System.Web.Security.SqlMembershipProvider.Validate User(String
> >>> username, String password) +78
> >>> System.Web.UI.WebControls.Login.OnAuthenticate(Aut henticateEventArgs
> >>> e) +161
> >>> System.Web.UI.WebControls.Login.AttemptLogin() +94
> >>> System.Web.UI.WebControls.Login.OnBubbleEvent(Obje ct source,
> >>> EventArgs e) +101
> >>> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> >>> +35
> >>> System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +115
> >>> System.Web.UI.WebControls.Button.RaisePostBackEven t(String
> >>> eventArgument) +134
> >>>
> >>> System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
> >>> eventArgument) +7
> >>> System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
> >>> sourceControl, String eventArgument) +11
> >>> System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection 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
> >>>
> >>>
> >> Sounds like it can't connect to the database. Are you sure it has
> >> connectivity, that the server is up and running fine, and that the
> >> connection string/configuration is good and all?

> >
> >


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Ersin Gençtürk ASP .Net 1 09-25-2007 07:33 AM
Date::Manip hours elapsed not business hours elapsed rutherf Perl Misc 2 10-28-2006 08:05 AM
'Timeout period elapsed prior to obtaining a connection from the pool.' - Please help. UJ ASP .Net 1 02-10-2006 01:09 PM
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Guoqi Zheng ASP .Net 4 06-03-2004 06:39 PM
Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Bob Johnson ASP .Net 0 08-07-2003 12:52 PM



Advertisments