Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding - MS SQL Server 2008

We have created our dashboard application using VB.Net+ASP.Net+SQL server 2008 which pulls the data from HPQC and display into web page.


Suddenly we started getting the error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" when we started accessing one of our dashboard page. 


Solution:
Step 1: In your connection string add "Connection Timeout = 0"
Step 2: SqlCmd.CommandTimeout = 0;


Its working fine now...Happy learning!