Last post Mar 17, 2014 04:58 AM by Fuxiang Zhang - MSFT
Mar 14, 2014 12:54 PM|CrymeLord|LINK
I'm not sure where to start looking and was hoping someone could point me in the right direction.
I recently converted an old intranet app from legacy asp to asp.net 4 MVC. The app is served through IIS 6 and connects to an SQL database
I've found out through trial and error that after about 200 seconds the app seems to lose connection to the SQL database if there is no querying activity going on.
I'm not sure where/what to look for or what general area I should be looking. Any help would be appreciated.
Mar 14, 2014 03:36 PM|aabruzzese|LINK
Try reading this thread:
They seem to be addressing the same concern as you mentioned.
Mar 17, 2014 04:58 AM|Fuxiang Zhang - MSFT|LINK
recently converted an old intranet app from legacy asp to asp.net 4 MVC. The app is served through IIS 6 and connects to an SQL database
Thanks for your post.
Based on your description, I see you convert a intranet app to asp.net mvc application. And host the asp.net mvc
application on IIS server. Then your web application cannot connect to the database.
For this issue, I think you should set the IUSR account to Read/Write for the DB file and folder where the DB file is located.
Hope this helps, thanks.