Whenever I have to reboot my production server, I lose all access on SqlConnections associated with a SqlDataSource binding for the Telerik Grid for ASP.NET AJAX.
I have never been able to determine the cause of the problem. Everything works fine on my development server. Everything works fine when I move it to the production server, but then if that server is rebooted, I lose all access to those Telerik Grids and I get the error pasted below.
Eventually after waiting... and waiting... and repeating attempts to access the web page with the Grid, I eventually get a connection and data populated in the Grid. What could be causing this problem?
What is the most reliable data source to use with data binding for the Telerik Grid in ASP.NET AJAX web apps? By reliable, I mean relatively trouble free data binding without worrying about mysterious connection problems like the one I experience whenever I reboot my production server. Oh, please do not criticize me for rebooting my production server. Yes, I know that I should avoid doing that whenver possible.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1