DotNetNuke Users Setup

I have recently started to learn ASP.Net and figured that DNN is a good starting point but battling to get DNN installed. I don't understand the need for 2 user logins. Here is my understanding. Please can you either confirm this is correct or provide the correct solution.

My interpretation:
1) ASPNET - this is a user login created by the .Net framework?

"need to grant the ASPNET user READ, WRITE, EXECUTE and DELETE permissions on the folder that DotNetNuke resides in." I understand this to mean that in Windows Explorer I tick 2 boxes viz. "Share the folder..." & "Allow network users to change my files"

In "Web Sharing" the following permissions are set:
Access permissions
Read - Yes
Write - No
Script source... - No
Directory browsing - No

Application Permissions - Scripts

SQL server - do I need to add ASPNET as a user in SQL server?
If yes then, what permissions does this user need?
public
db_owner
I don't think any others

2) DNN
My understanding is that I create a user in Windows e.g. "DNN_User"
In SQL Server I create a login for this user with the following settings:
SQL Server authentication
Server Roles - I don't know??
Database Access - Tick only the DotNetNuke database

My understanding is that Windows authentication is more secure than SQL authentication, so not sure why one would choose this less secure authentication method?

Thanks in Advance

Trevor
LVL 1
millscoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AerosSagaCommented:
"need to grant the ASPNET user READ, WRITE, EXECUTE and DELETE permissions on the folder that DotNetNuke resides in." I understand this to mean that in Windows Explorer I tick 2 boxes viz. "Share the folder..." & "Allow network users to change my files"

This account will need write permissions, you currently do not  have them.

------------------------------------------------------------------------------------------------

SQL server - do I need to add ASPNET as a user in SQL server?
If yes then, what permissions does this user need?
public
db_owner
I don't think any others

it will need an account DOMAIN/ASP.NET process will be what it shows up under.  if you make it owner, it would work for testing, but best idea is to create a SQL server account for this user and give permissions as needed, but for testing dbo is ok.
------------------------------------------------------------------------------------------------------------------
2) DNN
My understanding is that I create a user in Windows e.g. "DNN_User"
In SQL Server I create a login for this user with the following settings:
SQL Server authentication
Server Roles - I don't know??
Database Access - Tick only the DotNetNuke database

Windows authentication is not currently prebuilt into the DNN core, so you'll have to use SQL authentication.  It is planned, but will not make the DNN 3.0 upcoming release.  Make it owner to test then back the permissions down.  It will only need access to the DNN DB

Aeros
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.