• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Sporadic asp.net login issue

When using our software, only one customer complained about sporadic asp.net login issue.
Others are fine. It looks like not our software's issue since other customers are fine. When they have such issue, if they wait a certain time, they could login again. I really don't know why. It looks lilke a connection issue. Any help will be very apreciated!!!

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1099
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6291804
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6292993
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +522
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +182
1 Solution
This error means that the query is taking too long to process within SQL Server.  You could try rebuilding your table index(es), or streamline the query.  It might also be that another query is running at the same time which is using up all the resources so none are left for this particular query.
One customer, that's a patern. Maybe there's also a patern in when he's having login problemns. Such as he's the only one who's trying to loging at a moment a maintenance job is slowing your (sql) system down.
Or he's the only one who complains even when he can login a few minutes later.
jssong2000Author Commented:
This is a good idea. It worked.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now