Installing and Setting up SQL

Environment

  • DNN Platform
  • Evoq Content
  • Evoq Engage

 


 

Process

  1. Install SQL.

    1. Check compatible versions.

    2. Choose New SQL Server stand-alone installation...

      New SQL Server stand-alone installation

    3. Include any product updates.

    4. Accept the defaults in Feature Selection, Instance Configuration, and Server Configuration.

    5. In Database Engine Configuration, under Authentication Mode, choose Mixed Mode.

    6. Enter the password in the Enter password and Confirm password fields.

    7. Click Next.


      Screen_Shot_2019-10-22_at_12.40.12_PM.png

    8. Accept the defaults in the remaining dialogs.

  2. Create a SQL database for your website.

    1. Start the Microsoft SQL Server Management Studio (SSMS) app.

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

    3. Select New Database.

      Screen_Shot_2019-10-21_at_2.40.33_PM.png

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


      Screen_Shot_2019-10-21_at_2.43.36_PM.png

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

  3. Create a SQL user account.

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


      Under Security, right-click Logins, choose New Login.

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


      Choose SQL Server authentication. Uncheck Enforce password policy.

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

    3. Click OK.

  4. 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.

      Under your database > Security, right-click Users, choose New User.

    2. Set User type to SQL user with login.


      User type = SQL user with login

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


      Enter the new account's login name, then click/tap Check Names.

    4. Click OK.

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


      For Membership page, check db_owner.

 


Parent Topic

Related Tasks

Related Information

 

Back to top

Comments

0 comments

Please sign in to leave a comment.