Aug 21, 2009 12:26 PM|mdurthaler|LINK
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.
-- I also had a permissions issue with dropping indexes and re-adding them for what I was doing so there was more to do than just this. This error was the last thing to fix.
2) Tried the webconfig setting in the connection string but this didn't fly.
3) I'm working in Visual Studio so I highlighted the connection, selected Modify Connection | Advanced and sure enough ... there's a default timeout set for 15 seconds.
Having already tested my query for deleting a very huge file, I know it takes just over 2 minutes. Setting the timeout in visual studio (db connection advanced tab) also for 600 seconds seems to have worked.
So if anyone else sees this, here's another solution. A time warp would have been the best answer so that anyone from 2005 forward would have already seen this link.