DNN (DotNetNuke) ships with it's connection string as:
Server=(Your Server);Database=(Your Database);uid=(SQL Account);pwd=(Password);
After filling in the nessesary information for your server, I STRONGLY suggest that you add the following red text to the connection string.
Server=(Your Server);Database=(Your Database);uid=(SQL Account);pwd=(Password);
Min Pool Size=2; Max Pool Size=10;Connect Timeout=15;Pooling=true;Connection Lifetime=0;
In reality, I suggest using connection pools in all of your web and server applications.
Yes, my pool size is only 10. If you remember to close your connections, 10 connections have been known to support up to 1 million users.