Ignite Global Support Home
Submit a request
Sign in
Luis Fernandes
October 18, 2019 07:27
Follow
Other articles in this section
Setting Up DNN
How to disable File Change Notifications (FCNMode) To Improve Performance
Changing Date/Time settings for Assets/Modules (Files) uploaded from MMDDYYYY to DDMMYYYY
Unable to crawl for XLSX file contents from Search Bar
Troubleshooting Checklist: Migration
Deleted users appear as creators in Page History
Missing pages after an export
Assigning a Security Role to all existing users
Document Manager hides some file extensions
Setting account Auto Unlock time window
Console Modules missing after Upgrade to 9.1.1
Other Sections
DNN Corp. Customer Support
Installation
Setting Up DNN
Install and Set Up SQL
Luis Fernandes
October 18, 2019 07:27
Follow
Steps
Install SQL.
Check compatible versions.
Choose
New SQL Server stand-alone installation...
.
Include any product updates.
Accept the defaults in
Feature Selection
,
Instance Configuration
, and
Server Configuration
.
In
Database Engine Configuration
, under
Authentication Mode
, choose
Mixed Mode
.
Accept the defaults in remaining dialogs.
Create a SQL database for your website.
Start the
Microsoft SQL Server Management Studio
app.
In the
Object Explorer
panel, right-click on
Databases
, and choose
New Database...
.
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.
Under
Security
, right-click on
Logins
, and choose
New Login...
.
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.
In the
Object Explorer
panel, under
your database
>
Security
, right-click on
Users
, and choose
New User...
.
Set
User type
to
SQL user with login
.
Enter the username of the account you just created, then click/tap
Check Names
.
Under
Select a page
, select
Membership
, and check the
db_owner
database role membership.
Facebook
Twitter
LinkedIn
Comments
0 comments
Please
sign in
to leave a comment.
Comments
0 comments
Please sign in to leave a comment.