Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inquisitive123
Starting Member
11 Posts |
 Posted - 2010-11-23 : 02:01:47
|
| When creating a dataset in SSRS , after I enter the SQL query it just hangs for sometime and then displays the error message Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I have changed all the values that I can possibly think of in VisualStudio-Tools-Options,I think it is timing out after 30 secs, but not sure which setting should be changed, Can anyone pls advise.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-24 : 09:47:18
|
| try running the query you used for dataset directly in management studio query editor and see how long it takes to return results------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
krishna_krishnan
Starting Member
1 Post |
Posted - 2010-11-24 : 12:00:43
|
| Did you try checking the server settings??? When I faced some similar issue it turned out that the query failed as the server settings were done so that it failed after some time!! Is the query fetching a huge amount of data?Kris |
|
|
|
inquisitive123
Starting Member
11 Posts |
Posted - 2010-11-25 : 00:42:54
|
| The query takes about 6 mins to run in SSMS and returns only about 500 rows, but it has complex logic,joins .I have increased all settings in Visual STudio-Tools-Options, what server settings do you mean exactly. |
|
|
|
|
|
|
Timeout issue in SSRS