I am having the exact same problem. I can install a copy on our Application/Development server just fine (all modules, no errors), and on a client's web server. But on our Web Server (which has H-Sphere as well {may be irrelevant}), it appears to have installed everything correctly. The page loads and there is nothing on the home page and every module that runs a SQLdataprovider script does not install. I get the following error in the log viewer for each one of these modules.
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Access is denied: 'DotNetNuke.Modules.Survey'.
Message: System.IO.FileLoadException: Access is denied: 'DotNetNuke.Modules.Survey'. File name: "DotNetNuke.Modules.Survey" at System.Type.GetType(String typeName, Boolean throwOnError) at DotNetNuke.Framework.Reflection.CreateObject(String TypeName, String CacheKey) === Pre-bind state information === LOG: DisplayName = DotNetNuke.Modules.Survey (Partial) LOG: Appbase = file:///D:/HSphere/hshome/wfkids/wfkids.com/portal LOG: Initial PrivatePath = bin Calling assembly : DotNetNuke, Version=3.1.0.40589, Culture=neutral, PublicKeyToken=null. === LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Post-policy reference: DotNetNuke.Modules.Survey LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/portal/73953767/87b5889c/DotNetNuke.Modules.Survey.DLL. LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/portal/73953767/87b5889c/DotNetNuke.Modules.Survey/DotNetNuke.Modules.Survey.DLL. LOG: Attempting download of new URL file:///D:/HSphere/hshome/wfkids/wfkids.com/portal/bin/DotNetNuke.Modules.Survey.DLL. LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Post-policy reference: DotNetNuke.Modules.Survey, Version=1.0.0.39609, Culture=neutral, PublicKeyToken=null
I can manually install these modules, but I have noticed that other modules down the road are buggy as well. I also just tried using the default dbo user on our SQL server, and it didn't work either.
I set Full permissions on the folder (and push them through to all children) for ASPNET and NetworkService.
The really strange thing is I can use the same SQL server from our Application server instead of the Web Server, with the same dB User (dbo rights, but not the default dbo user), and everything still works fine. I only have the install issues on the web server (using any SQL server... I've tried 3 so far.).
I have the same setup:
Win 2003 Server
IIS6
SQL Server 2000
Hsphere Control Panel... (but it doesnt matter if the folder is in Hspheres root or not)
Any ideas?
Thank you,
Robert Zordel