DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

SQL Timeout during Installation of DNN 10.1.2

 3 Replies
 1 Subscribed to this topic
 28 Subscribed to this forum
Sort:
Author
Messages
New Around Here
Posts: 4
New Around Here
3 Engaged Reader
Engaged Reader
You are an engaged reader!

Try to setup a clean DNN 10.1.2 website and always get a timeout during the big INSERT statement of the table "lists". The statement inserts about 5000+ rows into the database and the DNN InstallWizard throws an error after approximately 40 seconds. I can see that about 2800+ rows are already inserted. So I know that everythings works (Website/SQL-Server/Rights/...) but it just takes to long. 

Where can I increase the timeout for the complete install script or the insert command. I tried a lot of settings in the webconfig and the SQL-Server the last two days but find no solution. Can anybody please help me and guide me a way where to increase the time limit for the installation wizard script. Thanks in advance for any recommendations. 

I am also wondering that the 5000 rows are a problem for the server, because it is a VM with 4 vCPUs and 24GB RAM (OS is MS Windows Server 2025 Standard, SQL-Server is MSSQL2022 Express). 

Regards, 
Wolfgang 

Veteran Member
Posts: 349
Veteran Member
3 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
I have installed DNN without issues on way worst machines, the whole install process should take 30 seconds to maybe a minute or 2. I would investigate for server performance issues...
Senior Member
Posts: 1322
Senior Member
3 Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
Lifesaver
Lifesaver
You're Life Saver!
New Poster
New Poster
Congrats on posting!
3 Engaged Reader
Engaged Reader
You are an engaged reader!
Posted By Daniel Valadas on 11/13/2025 7:59 PM
I have installed DNN without issues on way worst machines, the whole install process should take 30 seconds to maybe a minute or 2. I would investigate for server performance issues...

Yes, this is a weird issue.
That server is way faster than my local VM and I have never seen this TBH.

 

Advanced Member
Posts: 132
Advanced Member
Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
2 Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
SQL Express does have some processing limits, so it cannot use all of the resources available, but it shouldn't be an issue in this situation, unless the server is already overwhelmed with other activity?

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved