Permissions & Installation
Understanding the DotNetNuke SQL Database
If your responsibilities end at getting the basic site up and running, you won't need to know that much about SQL to get a DNN site going. You'll have to install SQL on your server and create an empty database to house the site. One of the advantages of the DNN SQL system is that one can create many different sites very quickly in this way.
Quite frequently, people run into problems when permissions come into play. To properly install DNN, the database has to be installed at the root of the server. If the installation isn't done in this way, the administrator will not have the proper access they need to make all the changes to the site. Make certain that you have this level of control when you sign up for your web host.
DNN SQL databases are like any other SQL databases. Information is stored in an organizational system based on columns and rows and the ability to change that information and the structure of the database is strictly controlled by the administrator. When you change the data in one of the SQL containers, the data that appears on the webpage that DNN creates for the user will change, as well. This and the incredible search features of the SQL database are among the reasons this system is so popular with very dynamic sites that have constantly updated information. DNN is a great platform with which to build your web presence.