Troubleshooting

Any type of error you receive in SSRS

Steps to Resolve SSRS Timeout Issues

Been awhile since I had posted anything and what better way to restart this blog than with some Timeout Issues. Now this list is designed for SSRS 2005, but you can put a few of these tips to use in 2008. Consider these steps in the below order. 1) Set the HttpRuntime ExecutionTimeout value to a greater value (ie 3 hours) on the Report Server How do you do this? Simple! a. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services. b....
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Friday, October 30, 2009 2:29 PM | Feedback (2)

401 Unauthorized access Error in SSRS

In the SSRS Reporting Environment, you may never encounter this error and you live a happy and easy life. We all know an SSRS report can easily ping your server to 100% CPU if you decide to export a 120 page report, to PDF, with charts, etc. etc. You may get a complaint that performance suffers in another application while running the reports and you want to fix it, but do not know how. Then one day you or someone at your firm has decided to do your SQL Server a favor and separate out SSRS from the...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Wednesday, September 16, 2009 1:16 PM | Feedback (0)