Hi,
I need your advice on this particulat problem.
My DBA tells me I can't create a DB Login for my DNN 4.8.1 install with db_owner permissions. Ok, so I have a document to help with the install (as I'm fairly green at this):
DotNetNuke Installation Guide v 1.0.03 (C. Nurse), Nov. 28, 2005
At the bottom of page 8, top of page 9, it is mentioned that db_owner is not actually required for the installation. Later, on pages 14 and 15, in the Data Provider Settings section, is mentioned minimum permisions required are :
- db_datawriter
- db_datareader
- db_ddladmin
- db_securityadmin
I cannot, for the life of me, get DNN 4.8.1 to install with only these permissions. I managed to install it but only after going to the Securables section for the DB User and granting Explicit Permissions for Execute on my DB object.
Also, during the DB Connection Test of the Installation Wizard, I always have to check the "Execute queries as DB Onwer" option other wise I get an "Object already exists" error the second time I run the test (or click the Next button). What exactly does "Execute queries as DB Onwer" mean as the user is clearly not the dbo?
Finally, when installation completes and probably unrelated to the dbo issue, I get the following Null Argument Exception (in french):
La valeur ne peut pas être null.
Parameter name: path1
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentNullException: La valeur ne peut pas être null.
Parameter name: path1
Source Error:
|
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
|
Stack Trace:
[ArgumentNullException: La valeur ne peut pas être null.
Parameter name: path1]
System.IO.Path.Combine(String path1, String path2) +2686595
DotNetNuke.UI.Skins.SkinDefaults..ctor(SkinDefaultType DefaultType) +127
DotNetNuke.Common.Globals.get_DefaultSkin() +31
DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +2812
DotNetNuke.Common.Globals.GetHostPortalSettings() +216
DotNetNuke.Common.Globals.GetPortalSettings() +79
DotNetNuke.Authentication.ActiveDirectory.HttpModules.AuthenticationModule.Init(HttpApplication application) +198
System.Web.HttpApplication.InitModulesCommon() +66
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +814
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +243
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +106
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +340
|
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
I install all Modules, all Auth services, no optional skins or containers, and no language packs.
My environment:
- Windows XP Pro SP2 (IIS 5.1)
- SQL Server 2005
- DNN 4.8.1
Any feedback is greatly appreciated.
R3T