Install and Set Up SQL

Steps

Install SQL.
1. Check compatible versions.
2. Choose 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. Accept the defaults in remaining dialogs.
Create a SQL database for your website.
1. Start the Microsoft SQL Server Management Studio app.
2. In the Object Explorer panel, right-click on Databases, and choose New Database....
3. Enter the name of the new database. Click/Tap OK.
  
  Note: Remember the database name, because it will be required by the DNN Installation Wizard.
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.
Give the new SQL user db_owner access to the new database.
1. In the Object Explorer panel, under your database > 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/tap Check Names.
4. Under Select a page, select Membership, and check the db_owner database role membership.