I am having some issues running one large report in SQL Server 2008 Reporting Services. It runs for around 10 minutes and times out. But if I were to run the query in the management studio for that report it returns the results in around an hour.
Can someone tell me if I am missing anything in the configuration? The user tells me it was running fine around a month back and I have not made any changes to this server for past couple months.