DNNCommunity / DNNCommunity/DNNDocs

Feedback for Install and Set Up SQL

Open
#398 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
CSS
Stars
24
Forks
55
PR merge metrics
No merged PRs in 30d

Description

According to Microsoft, Windows Security should be used to provide proper security, unless there is a special need for integrated security. In case of DNN, this would require IIS App Pool user to be registered as SQL Server user and being mapped just to the database of the current site. This omits the need for providing username and password in plain text in DNN web.config (just using "integratedSecurity=true" option) and being limited for sure to the current database.

BTW: IMO it is easier to map the created user to the database instead of creating manually the database user and map to a login. Default schema should be "dbo".
---
#### Document Details

⚠ *Do not edit this section. It is required for dnndocs.com ➟ Core Team processing.*

* Content Source: [set-up-sql](https://github.com/DNNCommunity/DNNDocs/blob/master/content/guides/tutorials/server/setup/set-up-sql/index.md/#L1)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.