I tried to call a stored procedure in SQL server, and it returned "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
". The source error is at:
myReader = aCommand.ExecuteReader();

The SP works on a SQL Query Analyzer, but takes more than 2 minutes. Some other SPs which take less time all work well in my ASP.Net application. Is there any parameter that I should set to lengthen the timeout time? I tried the connectionstring, but it doesn't work.