[Last Call] Learn how to a build a cloud-first strategyRegister Now


Sporadic asp.net login issue

Posted on 2011-10-26
Medium Priority
Last Modified: 2012-05-12
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
Question by:jssong2000
LVL 25

Accepted Solution

Rouchie earned 2000 total points
ID: 37036626
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.
LVL 25

Expert Comment

ID: 37037388
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.

Author Closing Comment

ID: 37037902
This is a good idea. It worked.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Screencast - Getting to Know the Pipeline
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question