MS SQL Reporting Services 2005 – Time Out Execution Error – Solution

21 Jun

During the last 2 weeks I Been working in a Report that have a great amount of calculations of different accounting GL accounts, the thing is that during the query and view creation with SQL Management Studio everything works nice with response from large query’s in 80 Sec (acceptable).

The Problem arrives when I began to use that query’s in the report construction in Visual Studio Business Intelligence Development Studio , I get error Time Execution Error – Timeout after 30 Sec of running.

This reference help me to identify a 4hr problem Ref:http://www.windows-tech.info/15/b4e1f506fe9c6f41.php

The actual solution to the problem was:

In Visual Studio under Tools – Options.

That resolve the TimeOut problem in the Report development with Visual Studio – Business Intelligence Development Studio.

I hope save some time to others

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: