DotNetNuke User Guide: Installation

Preparing to Install DotNetNuke for the first time consists of three steps.

• Enabling ASP.Net server requirements
• Choosing a database type
• Modifying your DotNetNuke Version 2.1.2 web.config file

Step 1: Enabling ASP.Net server requirements

Before uploading your files to the web server you must have the following Network permissions enabled on the server. Your portal will not work without these network rights.

• Windows 2000 Server: ASPNET user READ, WRITE, EXECUTE, and DELETE permissions on the root folder that will contain your DotNetNuke Portal
• Windows 2003: NETWORK SERVICE user READ, WRITE, EXECUTE, and DELETE permissions on the root folder that will contain your DotNetNuke Portal

You are now ready to upload your files to the web server.
Access Users: secure your database information by removing "READ" permissions from IIS on the following folder:

• DNNRoot\Providers\DataProviders\AccessDataProvider

Step 2: Choosing a database type

DotNetNuke supports 2 database types. You must choose one before starting to setup your portal.

1. Microsoft Access: Note -Your DotNetNuke portal comes pre configured to use this database type and no further preparation is required, however it is not widely supported by 3rd party developers and is not supported in DotNetNuke v3.
2. Microsoft SQL Server: This option requires an SQL server and database. You can use Microsoft’s free desktop SQL server or SQL 2000 server.

Step 3: Modifying your DotNetNuke Version 2.1.2 web.config file for SQL Server

To configure your portal you will need to know the SQL server name, database name, username and password. You must also make changes to prepare your Web.Config file.

1. Download and unzip the DotNetNuke file to your local directory
   Open your web.config file found in the folder root.
   Scroll down the file until you reach the following statement.
   

   <!–– Sql Server connection string for support of pre DNN 2.0 Private Assemblies
   The new connection string (for DNN 2.0) is in the section dotnetnuke (providers) ––>
   <appSettings>

2. In the next line add your database connection information where indicated

   <add key="connectionString" value="Server=Your.SQLServerName;Database=YourDataBaseName;
   uid=YourDataBaseUserID;pwd=YourDataBasePassword;"/>
   </appSettings>

   Continue scrolling down the page to modification 3

   <data defaultProvider="AccessDataProvider"

3. Change above "AccessDataProvider"  to"SqlDataProvider" then continue scrolling to modification 4.

   <providers>
   <clear/>
   <add name = "SqlDataProvider" type = "DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
   connectionString=”Server=Your.SQLServerName;Database=YourDataBaseName;
   uid=YourDataBaseUserID;pwd=YourDataBasePassword;"

4. Add your database connection information to the string below

   connectionString="Server=Your.SQLServerName;Database=YourDataBaseName;
   uid=YourDataBaseUserID;pwd=YourDataBasePassword;"

5. Save your web.config file.