Environment

• DNN Platform
• Evoq Content
• Evoq Engage

Process

1. Install SQL Server.

   1. Download the latest version of SQL Server by clicking the Download now button on the Microsoft SQL Server downloads page. For this process, we will use SQL Server Express.

   2. When presented with "Basic", "Custom", "Download Media" options, select "Custom" 
   3. Choose a media location with at least 1GB of free space available and click Install.

   4. Once the download completes, choose New SQL Server stand-alone installation...
      
      
      
      

   5. Include any product updates.

   6. Accept the defaults in Feature Selection, Feature Rules, Java Install Location, Instance Configuration, and Server Configuration.

   7. In Database Engine Configuration, under Authentication Mode, choose Mixed Mode. Note: If you already have SQL Server installed, you can update this setting with these instructions.

   8. Specify a password in the Enter password and Confirm password fields.

   9. Click Next.
      
      
      
      
      

   10. Accept the defaults in the remaining dialogs.

1. Create a SQL database for your website.

   1. Start the Microsoft SQL Server Management Studio (SSMS) app. If you do not have it installed already, it can be downloaded from the Microsoft downloads page.

   2. In the Object Explorer panel, right-click on Databases.

   3. Select New Database.
      
      

   4. Enter the name of the new database. Click OK.
      
      
      

      Note: Remember the database name, because it will be required by the DNN Installation Wizard.
      
      

2. Create a SQL user account.

   1. Under Security, right-click on Logins, and choose New Login.
      
      
      
      
      

   2. Enter the username, choose SQL Server authentication, add a password, uncheck Enforce password policy, and choose the database.
      
      
      
      
      

      Note: Remember the username and password, because they will be required by the DNN Installation Wizard.

   3. Click OK.
      
      

3. Give the new SQL user db_owner access to the new database.

   1. In the Object Explorer pane, under Security, right-click on Users, and choose New User.
      
      
      
      

   2. Set User type to SQL user with login.
      
      
      
      
      

   3. Enter the username of the account you just created, then click Check Names.
      
      
      
      
      

   4. Click OK.

   5. Under Select a page, select Membership and check the db_owner database role membership.
      
      
      

Parent Topic

• Setting Up DNN

Related Tasks

• Enabling and Setting Up IIS
• Running the DNN Installation Wizard

Related Information

• DNN Wiki: Setting up Your Module Development Environment
• Setting up your DotNetNuke Module Development Environment  by Chris Hammond
• DNN Community Blog: Installing DNN  by Clinton Patterson

Back to top