Timeout Error in SSRS While adding a new dataset

Question

3.50/5 (2 votes)

See more:

HI , iam trying to add a dataset with query type as STORED PROCEDURE ,when i did this it is taking some time and shows up with this error,i checked the datasource and the result list of store proc everything works fine in sql server ,but when i try to add it as a new dataset it is coming up withthis error:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
i tried to look for this but i never found a clear answer ,i am using Visual Studio 2008 BIDS forRDL creation. can any one please help me out
Thanks in advance

Posted 7-Mar-11 3:48am

makwith9789

Add a Solution

2 solutions

Solution 1

Found the answer increased time out time from 15 to 30 and it worked

Posted 7-Mar-11 4:40am

makwith9789

Comments

Henry Minute 7-Mar-11 11:04am

Well done!

Please mark your question as solved, so that people will not waste their time. :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-03-07T04:46:00

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

This simply means the connection string used is not able to connect with the server and get the data back. Further, there is a connection timeout for queries too. Set it to some high value and check what happens.

It has to do with proper connection string and increasing the query timeout, both in the Dataset configuration of your RDL in BID's designer.