Dec 04, 2009 04:48 PM|blarticus|LINK
I was having this problem with my own DNN website as well. This one bit of functionality would spin for about 30 seconds and then throw the good ol SQL timeout exception...
"The post is 5 years old but I ran into this with a DNN site and there were a few things to correct:
1) Sign in to Sql 2008 Exp as SA and make sure the timeout is adequate -- it was, at 600 seconds."
This can be found by logging into your SQL server as SA, right clicking on the root(machine name) and selecting properties...you should see Connections under the 'select a page' menu. Towards the bottom you will see 'Remote Query timeout (in seconds, 0
= no timeout)
Mine was indeed set to 600...but was clearly not working...so I set it to 0 and poof! The problem dissappeared!!