Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feedback for Install and Set Up SQL #398

Open
sleupold opened this issue Nov 14, 2019 · 0 comments
Open

Feedback for Install and Set Up SQL #398

sleupold opened this issue Nov 14, 2019 · 0 comments

Comments

@sleupold
Copy link

sleupold commented Nov 14, 2019

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant