SQL Connection TimeOut Error

See more:

SQL-Server-2005

C#

VB

ASP.NET

, +

Hi,

I have a SP Which fetch data from three different database.
To fetched the data it takes approximately 40-50 seconds.

When I call this SP from my development environment i.e. Visual Studio Asp.Net 3.5 (Local PC) it works fine.

But when i deploy the things on live it gives me below error

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

I tried setting Connect Timeout, Command Timeout, Execution Timeout with some max values. But I failed. So now i need your help.

Valid Answers are appreciated.

Thank you.