[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

DotNetNuke Users Setup

Posted on 2004-11-07
2
Medium Priority
?
437 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:millsco
1 Comment
 
LVL 17

Accepted Solution

by:
AerosSaga earned 1500 total points
ID: 12522926
"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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question