Alright, you asked for it :) Take a deep breath!
First let me qualify that my experience with Nuke is on the PHP/Linux side of the spectrum, though I'm a MCSE 2000 & 2003, I normally work with PHP/Linux for all my my apps. This is for a friend of mine.
It is on a W2K3 R2, using SQL Express 2005, .NET 2.0 and the latest 4.8.4 DNN download. We are setting up a local site, and importing the data from the live production site to the local site for development.
If I understand everything correctly using the install manuals (thanks Mitchel). The basics should be as follows.
Install .NET, IIS, SQL then DNN. (abridged version)
I have a simple test site working so I know that IIS is working. I can query the DB, so I know that SQL is working I can see the main page in DNN, so some of it is working. .NET is working or the install process would bomb and SQL would not install.
So I installed DNN 4.8.4 fresh install. I had on several of the installs installed it into a Virtual Directory call DotNetNuke, but later found out that this is not the best solution, because the images will not work, unless they are in the web root of IIS, not a virtual directory. The permissions on the folder have bene modded to reflect the Network Service having full control and being propagated to all subfolders.
So the latest installs are in the c:\inetpub\wwwroot folder with no virtual directory. I'm having to assign a port (8080) to the IIS site, because 80 is in use by another application that I can not change. So the local site is http://192.168.0.10:8080
Ok, now the fun stuff. I have had the following errors on various fresh installs.
1. Login link and register link return "Page Not Found" (which seems to be a very common issue, which I had twice and could not find the answer to) - Nuked it all to start over.
2. Module Load Warning - One or more of the modules on this page did not load. This may be temporary. Please refresh the page (click F5 in most browsers). - Posted several posts on the forum, never got a working answer - Nuked it all to start over.
3. Can't log in to admin account after importing the live DB. Nuked it all to start over.
4. Machine Key Errors after importing the live DB. - Found fixes, but then encountered one of the above or below issues - Nuked it all to start over.
5. Access to the path 'C:\DotNetNuke2\Portals\_default\03.00.08.txt' is denied. Found fixes, but then encountered one of the above or below issues - Nuked it all to start over.
6. There were more, but I'll keep this brief.
So with all the above being said, I have once again wiped it all out and started from fresh using Mitchel's guide. The install is working after several small hang-ups. But everything installed successfully.
Now I'm importing the LIVE DB in. I used the following to copy the DB in and it was successful:
RESTORE DATABASE RIVERFRIENDS
FROM DISK = 'C:\DotNetNuke\Microsoft SQL Database\riverfriends_backup_20082561130.bak'
WITH MOVE 'riverfriends_log' TO 'C:\DotNetNuke\DotNetNuke_log.ldf',
MOVE 'riverfriends_dat' TO 'C:\DotNetNuke\DotNetNuke_dat.mdf'
Processed 3880 pages for database 'RIVERFRIENDS', file 'riverfriends_dat' on file 1.
Processed 3 pages for database 'RIVERFRIENDS', file 'riverfriends_log' on file 1.
RESTORE DATABASE successfully processed 3883 pages in 15.916 seconds
(1.998 MB/sec).
Changed the PortAliase to 192.168.0.10/dotnetnuke
Copied the data from the old install (skins ...) to the new install
Verified permissions
Visited the site and now, I get an new error.
Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------
Email
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.IndexOutOfRangeException: Email
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.
Stack Trace:
[IndexOutOfRangeException: Email]
System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
+1433771
System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +102
System.Data.SqlClient.SqlDataReader.get_Item(String name) +12
DotNetNuke.Entities.Portals.PortalController.FillPortalInfo(IDataReader
dr, Boolean CheckForOpenDataReader) +723
DotNetNuke.Entities.Portals.PortalController.GetPortal(Int32 PortalId)
+184
DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32
TabId, PortalAliasInfo objPortalAliasInfo) +121
DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +82
DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +3303
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
My webconfig connection info is below (yes the passwords are real, but it's local so it really doesn't matter).
<connectionStrings>
<!-- Connection String for SQL Server 2000/2005 -->
<add name="SiteSqlServer"
connectionString="Server=SERVER1\SQLEXPRESS;Database=RIVERFRIENDSuid=dotnetnuke;pwd=dotnetnuke;"
providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2000/2005 - kept for backwards
compatability - legacy modules -->
<add key="SiteSqlServer"
value="Server=SERVER1\SQLEXPRESS;Database=RIVERFRIENDS;uid=dotnetnuke;pwd=dotnetnuke;"
/>
So, after three weeks, I'm still no farther along that I was before. However I did discover that using the phrase "I can't log on" will get you the silent treatment faster that yelling Hi Jack! on a plane will get you shot.
Thanks
Joe