B) Customizing the web.config file
This step is only necessary if you intend to use DNN with MS SQL database backend. Skip to Step C if you want to use MS Access as database backend.
- Open the Web.config file (under root) with any text editor.
- Edit the line
<data defaultProvider="AccessDataProvider" >
to
<data defaultProvider="SqlDataProvider" >
- Update the database connection information
<add name = "SqlDataProvider" type = "DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
connectionString = "Server=<localhost>;Database=<DB_NAME>;uid=<User_Name>;pwd=<DB_password>;"
providerPath = "~\Providers\DataProviders\SqlDataProvider\" objectQualifier = "DotNetNuke" databaseOwner = "dbo"
/>
Update the highlighted fields with your account information.
Note: objectQualifier will be prepended to the table names. You can leave it blank or set it as whatever you wish.
Note: To avoid any conflicts, we would highly recommend using a fresh database for the application install.
C) DotNetNuke Setup
- Open your browser and navigate to http://yourdomain.com/
- DotNetNuke will setup all the database objects when it first loads. This process MAY run for several minutes. DO NOT hit the stop button on the browser