Installing DotNetNuke 4.5.5 Locally 

Installing DotNetNuke can be somewhat difficult at times, therefore I am writing this article to give you a full step by step guide to installing DotNetNuke on a Windows XP Pro system. The instructions are similar for Windows 2000 and XP Home but might vary slightly, I have tried to note as many differences as possible. Windows Vista installation is similar but requires a few different steps relating to IIS.  This article is a re-visit to my first article of this type geared towards DotNetNuke 4.4.1..

Prior to following this instruction guide please ensure that you have downloaded the "install" version of DotNetNuke 4.5.5 from http://www.dotnetnuke.com.  You can save the zip file to your desktop for the time being.  You will also need to have SQL Server Express 2005 installed, (Other versions work, but these instructions might not match 100% on other versions).  Lastly you must be logged in to your machine with administrative permissions.

The setup will be broken into the following 3 sections; creating the needed SQL Serveer database and user account, unzipping DNN and configuring the web.config file, and finally setup of the virtual directory and starting DotNetNuke.

Creating SQL Server Database

  • Start SQL Server Management Studio Express (SSMSE), (if you don't have this please install it from here.)
  • Once SSMSE has opened, please note the "Server Name" of the server that you are connecting to, this is the full text of the information in that field. (Circled in below picture) 
  • Once you have connected and opened the utility you will want to expand the node for your server name as located in step 2
  • Right Click on the "Databases" node and select "Create New Database"
  • Specify a name for your database, I will use DotNetNuke455 for this example, then click create 
  • Now expand the "Security" node, then right click on "Logins" and select add
  • Provide the information for the dnn account, be sure to select "SQL Server Authentication" and remember the password. (If SQL Server Authentication is not available see this to enable mixed mode on your server) 
  • Now select "User Mappings" and check the box next to your newly created database at the top, then select the "dbowner" role from the listing at the bottom, this maps the account to have full access to your database. 
  • Click "Create" to have your user account created. Once this is completed you are now done with the databse setup. Please remember the database server name from step two and the username and password used to create the SQL Server account as we will be using this in the next section

Unzipping and Configuring DotNetNuke

All files from the DotNetNuke install zip must be extracted to a common folder, typically this folder is created as a sub directory of C:\inetpub\wwwroot. The instructions below will be based on installation to this location, if you desire to install DotNetNuke at a different location simply substitute your folder path anytime it is referenced in the below instructions.

  1. Using windows explorer navigate to c:\inetpub\wwwroot, then right click and select "New" -> "Folder" and create a folder called "DotNetNuke455". This folder will become the install directory for DotNetNuke
  2. Right click on your newly created file and select "Sharing and Security"
  3. Switch to the security tab, if you do not see the "Security" tab, you will need to disable the "Use Simple File Sharing" option in your Folder View Options.
  4. Click "Add.."
  5. In the textbox type ASPNET if on Windows 2000/XP or NETWORKSERVICE if on Windows 2K3/Vista, then press ok
  6. Under permissions for this account check the box for full control, then press "Ok" to save the changes
  7. Open the DotNetNuke 4.5.5 Install Zip package
  8. Select "Extract All Files/Folders" 
  9. For the extraction location select the folder you created in step 1
  10. Once all files have been extracted you need to edit the "Web.config" file located in the root of the DotNetNuke folder
  11. Modify the circled sections of the web config, you will need to set this up to connect to your database, so substitute your values for "Server", "Database", "uid", and "pwd".  This format of connection string will work for both SQL 2000 and SQL Express.  You may use other valid connection string settings, you may visit http://www.connectionstrings.com for assistance with other formats
    Connection String Values to Change
  12. Also inside the web.config look for a setting called <add name="AutoUpgrade" value="True" />, change the value on this to "False"
  13. Lastly inside the web.config look for a setting called <add name="UseWizard" value="True" />, change the value on this to "False"
  14. Save the modified document

The above finishes the actual configuration of the DotNetNuke file system first we created the needed directory, then we assigned the proper file permissions, then we configured the web.config file to not only connect to the database but to also do some preventative settings changes to secure the site.

Setup Virtual Directory and Start DotNetNuke

Now that we have the database and file system setup we will proceed to the final step of setup, configuring IIS to host your website.

  1. Open the IIS Snap-In tool, this can be found via "Start" -> "Settings" -> "Control Panel" -> "Administrative Tools" -> "Internet Information Services"
  2. Expand the root notes until you can expand the "Default Web Site" node
    IIS Default Web Site View
  3. You should see your application folder listed under the "Default Web Site", right click on the folder and select "Properties"
  4. On the first tab, click the "Create" button next to the application name, you should then see DotNetNuke455 listed
    IIS Directory Settings
  5. Now, switch to the "Documents" tab. Remove all current entries and add "Default.aspx" to the listing. Your window should look like the following when complete.
    IIS Documents Settings
  6. Now, switch to the "Dierectory Security" tab
  7. Click "Edit" in the "Anonymous access and authentication control"
  8. Ensure that a checkmark is included in the "Anonymous Access" box at the top of the screen then click "Ok" to exit
  9. Now switch to the "ASP.NET" tab and ensure that "2.0.50727" is selected for the ASP.NET version
  10. Click "Ok" to save your changes and complete the IIS setup
  11. Now open Internet Explorer and navigate to "http://localhost/DotNetNuke455/Install/install.aspx
  12. You should see some test indicating the DNN installation progress then a link that says "Click here to access your portal"

This walks you through the entire setup process to get a local copy of DotNetNuke working with SQL Server 2005 Express. This installation guide can help you get up and going on a hosting provider as well, simply noting that the first portion of the setup is typically completed by your web hosting provider.

If you have any comments please leave them below, if you have any trouble and need assistance please utilize my forum to request assistance!

Posted by Mitchel on Thursday, July 26, 2007
 

Comments

The following site is still under construction
http://localhost/DotNetNuke455/Install/install.aspx

What should I do?

By Wissam on Monday, July 30, 2007 at 1:28 AM

I've the same problem:

DotNetNuke Error: - Version 04.05.05

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

The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.

By Gonzalo on Monday, July 30, 2007 at 3:35 AM

I would ensure that both connection strings are set properly.

Did your installation screens appear showing the proper messages including successful install?

By mitchel.sellers@gmail.com on Monday, July 30, 2007 at 3:46 AM

Great,
In the WebSite IIS properties I checked 'script source access' and I selected the option: 'Scripts and executables' in the Execute Permissions and it runs ok

Thks

By Gonzalo on Monday, July 30, 2007 at 3:48 AM

this is my connection string

connectionString="server=localhost\\SQLEXPRESS;database=DotNetNuke455;uid=dnn;pwd=*****;"

now I have this error: Instance Failure (unhandeled exception)

Server.ScriptTimeout = Integer.MaxValue
Select Case GetUpgradeStatus() <--- Error here!
Case Globals.UpgradeStatus.Install
InstallApplication()

By Wissam on Tuesday, July 31, 2007 at 1:11 AM

Try removing the localhost portion of the servername.

By mitchel.sellers@gmail.com on Tuesday, July 31, 2007 at 3:29 AM

No, it's not working :(

By Wissam on Tuesday, July 31, 2007 at 11:01 PM

Can you connect to your SQL Server instance via management studio? Have you confirmed that the server name you have entered matches EXACTLY to what is displayed in management studio?

By mitchel.sellers@gmail.com on Wednesday, August 01, 2007 at 3:43 AM

For SQL Express, the server should be refered to as:

.\SQLExpress

By Tim on Wednesday, August 01, 2007 at 2:46 PM

So the completed string would be:

connectionString="server=.\SQLEXPRESS;database=DotNetNuke455;uid=dnn;pwd=*****;"

By Tim on Wednesday, August 01, 2007 at 2:48 PM

I am getting the following error, please help:


Server Error in '/DotNetNuke455' Application.
--------------------------------------------------------------------------------

Failed to access IIS metabase.
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.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.

The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904.

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:


[HostingEnvironmentException: Failed to access IIS metabase.]
System.Web.Configuration.MetabaseServerConfig.MapPathCaching(String siteID, VirtualPath path) +3609834
System.Web.Configuration.MetabaseServerConfig.System.Web.Configuration.IConfigMapPath2.MapPath(String siteID, VirtualPath vpath) +9
System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +169
System.Web.CachedPathData.GetConfigPathData(String configPath) +382
System.Web.CachedPathData.GetConfigPathData(String configPath) +243
System.Web.CachedPathData.GetApplicationPathData() +68
System.Web.CachedPathData.GetVirtualPathData(VirtualPath virtualPath, Boolean permitPathsOutsideApp) +3503459
System.Web.Configuration.RuntimeConfig.GetLKGRuntimeConfig(VirtualPath path) +189




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

By Stilian Gueorguiev on Wednesday, August 01, 2007 at 6:03 PM

Stilian,

You will need to uninstall and re-install ASP.NET on your machine.

Open a command prompt and move to the following directory.

C:\Windows\Microsoft.net\framework\v2.0.50727

Then type the following command to uninstall

aspnet_regiis.exe -u

Then type the following command to re-install

aspnet_regiis.exe -i

You should now be set to go!

By mitchel.sellers@gmail.com on Wednesday, August 01, 2007 at 6:22 PM

Thanks a lot Mitchel. The error disappeared but now I am getting another one:

Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.




I am going to go and redo all of the instructions form the beginning to make sure i did not skip a step before posting again. Thanks for the help!

By Stilian Gueorguiev on Wednesday, August 01, 2007 at 8:03 PM

Most likely this error is an ASP.NET config error and nothing related to your DNN installation.

If you look at the Event Log in Control Panel under windows you should see an error listed for ASP.NET. If you can provide that error we should hopefully be able to get you going.

Also, if possible please post the error under the forum to move this type of troubleshooting out of the comments! (Thanks!)

By mitchel.sellers@gmail.com on Thursday, August 02, 2007 at 3:34 AM

Thanks a lot for the help, i got it to work, just a final question before i refer myself to the forums, how so I know it has installed succcessfully. I am currently getting a



This site is currently Unavailable
Please check back later


when i go to the URL

Stilian

By Stilian Gueorguiev on Thursday, August 02, 2007 at 12:40 PM

I am not sure what that would be caused by.

What does the page look like?

By mitchel.sellers@gmail.com on Thursday, August 02, 2007 at 2:33 PM

Thank you for these instructions. When I installed 4.5 I ran into several bugs. I uninstalled and installed 4.4. and it works. I try to see my site from the web but I get a 403 permissions error any suggestions?
Thanks again

By Randy on Friday, August 03, 2007 at 1:03 PM

You will want to make sure that you have a portal alias setup for your external ip address/url if you accessed the site the first time from localhost.

This can be done via the Site Settings when logged in as host.

By mitchel.sellers@gmail.com on Friday, August 03, 2007 at 1:25 PM

Thanks. Saved me alot of time.

I have one last question. I am working on a page for my boy scout troop and I would like the ability to let users download large files of videos or pictures ziped, about 150meg any suggestions? when I try to upload the file I just get page not availiable screen.
TIA
Randy

By Randy on Sunday, August 05, 2007 at 10:11 AM

This site is currently Unavailable
Please check back later
I had version 4.5.1. it work fine. Now i want to install 4.5.5 i made what say the documentation and have this error. I make a new installation but i have this error. Win2003/SQL2000. Anybody can help me?

By Alejandro Angel on Monday, August 06, 2007 at 12:12 PM

Server Error in '/DotNetNuke455' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The configuration section cannot contain a CDATA or text element.

Source Error:


Line 24: name="SiteSqlServer"
Line 25: connectionString="Server=(local);Database=DotNetNuke455;uid=rud;pwd=shafa;"
Line 26: providerName="System.Data.SqlClient" />
Line 27: -->
Line 28: </connectionStrings>


Source File: c:\inetpub\wwwroot\dotnetnuke455\web.config Line: 26


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832


what should i do????

By blacko on Monday, August 06, 2007 at 7:43 PM

That is one that I have not seen before.

I would try to re-save the file and see if you happen to get any different results.

From the looks of it you do have it setup properly.

By mitchel.sellers@gmail.com on Tuesday, August 07, 2007 at 4:29 AM


I too get an error messsage like so:

"Error Installing DotNetNuke
Current Assembly Version: 04.05.05
ERROR: Could not connect to database specified in connectionString for SqlDataProvider"


I have no default website and this is the name of my development server:
"sypadevelopment"

therefore my install file seems to be here:
http://sypadevelopment/DotNetNuke_2/Install/install.aspx

If I enter http://localhost...
I get a 'page not found message'

my connection string is:

connectionString="Server=(sypadevelopment);Database=DotNetNuke_2;uid=****;pwd=****;"

I have tried changing server name to "Server=(local)

but I get the same error message.

I am running XP Pro service pack 2 , with IIS 5.1
version installed: 'DotNetNuke_04.05.05_Install' file.

regards,
mark

By mark on Tuesday, August 07, 2007 at 4:47 AM

Further Info from above:

1. How can I test the connection from the database?

I presume I can connect to the database; I have been in SQL Server Management Studio Express and can right click on my database name: DotNetNuke_2 and select properties (I can also view connection properties).

But not sure how to "test connection settings".


<b>2. DotNetNuke installation Wizard</b>

Initially I had to enter the actual IP address of the server to get this working or connect via IE on my own browser (and not the server's browser), but strangely enough it seems to open up now from the server's browser with the server name.

Anyway I get as far as:
<i>"Configure Database Connection"</i> screen, then get this error message:
.....................................................

Invalid value for key 'attachdbfilename'.


I entered:
SERVER: (myservername)
FILENAME: DotNetNuke_2

By Mark on Wednesday, August 08, 2007 at 2:31 AM

Mark,

First of all if you are able to connect via SQL Management Studio, be sure to note the servername that appears in the "connection" box when you open that utility.

Then since you have created a db already, you need to use a connection string that looks like this.


connectionString="server=.\SQLEXPRESS;database=DotNetNuke455;uid=dnn;pwd=*****;"

Placing the proper values in for server, database, username, and password.

By mitchel.sellers@gmail.com on Wednesday, August 08, 2007 at 5:38 AM

Further Info:



It turns out, I wasn't using the SQL Server 2005 Express version of the connection string.
I have since changed it (as shown below):

.............
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />
connectionStrings>

<appSettings>

<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" />
.............

However, I can't find anywhere to edit the above settings - Do they need editing?

I beleive there is no need to assign a uid / password?
(I have left the Database.mdf name the same.)




Now my Install wizard comes up with the following errors:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 16
Number: 1813
Message: Could not open new database 'C:\INETPUB\WWWROOT\DOTNETNUKE_2\WEBSITE\APP_DATA\DATABASE.MDF'. CREATE DATABASE is aborted.

Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 15350
Message: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\DotNetNuke_2\website\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Index #: 2
Source: .Net SqlClient Data Provider
Class: 0
Number: 5111
Message: File activation failure. The physical file name "C:\Inetpub\wwwroot\DotNetNuke_2\website\App_Data\Database_log.ldf" may be incorrect.

Index #: 3
Source: .Net SqlClient Data Provider
Class: 0
Number: 5129
Message: The log cannot be rebuilt when the primary file is read-only.

By Mark on Wednesday, August 08, 2007 at 6:43 AM

Mark,

It appears to be an issue with dynamic attachment of the db.

I personally follow the instructions listed above which result in an actual database being created and a specific login.

By mitchel.sellers@gmail.com on Wednesday, August 08, 2007 at 6:50 AM

I'm doing clear install on Windows XP Pro SP2 using Visual Studio 2005 and SSMSE 2005.

I'm have the same problem that is :
{
Error Installing DotNetNuke

Current Assembly Version: 04.05.05

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

}

I'm pretty sure it is the connectionstrings problem after much testing. Just wonder how to fix it.

Is that due to security issues?

Also, sometimes when I edit those strings, It leads me to " Underconstruction.html" page....

I really hope that you can help us fix this thing. I owe you one.

Also, please don't just copy 4.4.1 version installation as 4.5.5....

By George Lew on Wednesday, August 08, 2007 at 8:32 AM

George,

The process is EXACTLY the same for all versions of 4.x.

The issue you are experiencing is due to differences in connection string information which no tutorial can give you 100% direction on how to configure as SQL Server can be configured in many ways.

With that in mind, the easiest manner is to simply copy the server name that is displayed with SSMSE then place the other specific information in your connection string and to NOT dynamically attach a database.

By mitchel.sellers@gmail.com on Wednesday, August 08, 2007 at 8:44 AM

I'm sorry...

Ok, this is the original string I've downloaded:

Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;

Then I've tried to remove AttachDBFilename... and used [sa] in database as user with full assess etc.

I've also tried yours example:

Server=DHNVRP1S\SQLEXPRESS;Database=DotNetNuke455;uid=dnn;pwd=dnn;

DHNVRP1S is my pc name, I've also tried replace with a "."

It's 2am here...struggling for the past 14 hours wakaakka....sorry for the trouble...

By George Lew on Wednesday, August 08, 2007 at 9:03 AM

George,

No worries...I just want to make sure that everyone know that the process is still the same.

For your issue, have you double checked in the Surface Area Configuration that you allow external connections? My simplified connection is typically the best bet...I have used it on the hundreds of installations that I have completed without issue.

By mitchel.sellers@gmail.com on Wednesday, August 08, 2007 at 9:06 AM

Ya, I did that also...

Configuration and suface Configuration also set to highest accessible.

I even turn off my all firewall and antivirus for the past 10 minutes to run it....can't...

Maybe...afterall...I just need to restart my pc....so...I go to bed 1st....hope tomorrow got some miracle...

By George Lew on Wednesday, August 08, 2007 at 9:23 AM

HI, I've figured out the problem!!!

use "localhost" !

server="localhost;....."

Somehow, I think "localhost is needed in Branded PC with OEM XP PRO installed...

By George Lew on Wednesday, August 08, 2007 at 4:49 PM

i solve the connectionstring problem already.

ConnectionString="Server=localhost;Database=DotNetNuke455;uid=dnn;pwd=****;"

By How on Wednesday, August 08, 2007 at 4:50 PM

Getting crazy of it! Have tryed it for many times, many configuration's, readed al the post comments, but still getting no result when opening: http://localhost/DNN/install/install.aspx
or http://localhost/DNN
I'm getting the message in IE: "The page cannot be found. (blablabla) HTTP Error 404 - File or directory not found.
Internet Information Services (IIS)"
Is this an IIS problem, or a connection string problem in web.config ?

Windows 2003 Server SP2
SQL Server 2005 Express
computername: webserver,
already tried folowing server names in the connection string parameter:
.\SQLExpress | WEBSERVER\SQLEXPRESS | .\webserver | localhost
None of them works, same problem.
Can anyone help me ?

By aadhoog on Sunday, August 12, 2007 at 12:31 AM

If you are getting a 404 error it is most likely NOT due to the connection strings.

I would ensure that you have ASP.NET configured properly (And using version 2.0.50727) I would also then ensure that you have default.aspx listed as a default document.

By mitchel.sellers@gmail.com on Sunday, August 12, 2007 at 8:06 AM

Don't know WHAT to configure in ASP.NET !? I am using version 2.0.50727, and also Default.aspx is the only one listed as default document.

I have tried to do the installation a few times on a clean VMWare session, but every time i got the same problem....
Really don't know what i am doing wrong every time.

By aadhoog on Sunday, August 12, 2007 at 11:35 AM

aadhoog,

A few things.

1.) Ensure that in the virtual directory that you have the proper version selected

2.) Test accessing a image or other NON aasp.net file types. This will isolate an issue with either IIS or ASP.NET

By mitchel.sellers@gmail.com on Sunday, August 12, 2007 at 11:40 AM

Can you just tell how did you solve the connectionString problem, where do you use localhost

<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />

By hari on Monday, August 13, 2007 at 1:39 AM

Can you just tell how did you solve the connectionString problem, where do you use localhost

<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />

By hari on Monday, August 13, 2007 at 1:39 AM

How to Install DotNetNuke 4.5.5
Please Help Me!
Firends Help Me With Vedio

By morad on Tuesday, August 14, 2007 at 12:34 AM

How To Install DotNetNuke Source Code Ver 4.05.05.
Please Help Me!!!

By Peter on Tuesday, August 14, 2007 at 1:13 AM

morad/peter,

If you have specific questions on how to install please use the forums to ask questions!

By mitchel.sellers@gmail.com on Tuesday, August 14, 2007 at 3:43 AM

Mitchel,

I can, for example, browse to: http://localhost/DNN/logo.gif, that works fine, the logo.gif is displayed in IE, so it seems not to be an IIS problem, but if go to http://localhost/DNN/Install/install.aspx its not displayed and i get the "The page cannot be found, HTTP Error 404 - File or directory not found." message.

I have also given, for the test, Everyone Full Control permissions on the DNN folder, marked "Script source access" but same problem.

Is there any DNN log file i can look at to see what's the problem ?

By aadhoog on Tuesday, August 14, 2007 at 11:55 AM

I am CREATION Directory To IIS The DotNetNuke 4.5.5 Source Code But When Runing ASP.NET 2.0
runtime Error SHOUT!!

By Peter on Wednesday, August 15, 2007 at 6:26 AM

aadhoog, I had a similar issue last time i installed php on a 2003 machine. I'm sure there are multiple ways for this to happen, but for me I had changed all the properties to what i needed under "Web Sites" but not under "Default Web Site" So they had different settings. IIS didn't know where to send any file with a .php extension, and the 404 error was showing. So you might just double check that your settings under Default Web Site or whatever website your files are in are set correctly. If all of the extensions are listed properly than i would double check that your extensions are pointing to the correct dll under Home Directory - Configuration. For me my asp.net dll is in c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll - Hope that helps

By JimmyC on Thursday, August 16, 2007 at 10:59 AM

Hi! Mitchel
I see to installing DotNetNuke 4.5.5 this error:
Error 1 It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. c:\DotNetNuke\Website\Web.config 61
Please Help me!

By Peter on Saturday, August 18, 2007 at 1:16 AM

Peter,

Ensure that the virtual directory is setup to be at the root of where you placed DNN?

So, basically make sure that where DNN is, is the ONLY place that has a web.config file.

By mitchel.sellers@gmail.com on Saturday, August 18, 2007 at 8:30 AM

Hi! Mitchel,
I got the same problem like Peter. DNN directory is "C:\inetpub\wwwroot\dotnetnuke455\web.config".
Please help.

By Memoranda on Saturday, August 18, 2007 at 3:21 PM

Hi! Mitchel
Please More EXPLAIN... (I Setuping DNN Source Code Ver 4.5.5)

By Peter on Monday, August 20, 2007 at 10:30 AM

Peter,

Please make a post in my forum for help with this issue.

By mitchel.sellers@gmail.com on Monday, August 20, 2007 at 12:00 PM

Mitchel,
I donot Know Your Forum!

By Peter on Monday, August 20, 2007 at 8:48 PM

Peter,

The "Forums" link in the left navigation menu.

By mitchel.sellers@gmail.com on Tuesday, August 21, 2007 at 4:34 AM

Hi Peter,
I've followed your dnn 455 install instructions verbadum.

Using:
Win 2003 server enterprise
SQL 2005 enterprise

Same results after runnung the http://localhost/dnn455
It grinds a bit then redirects to
http://localhost/dnn455/Install/UnderConstruction.htm
The text on the page says: "This site is currently under construction" "Please check back later"
Looking at the db, there's no tables created yet so I suspect it's a SQL perms issue but I can go to another machine and manually create a test table with the sql-Usr acct.
Any thoughts?

By MarkQ on Tuesday, August 21, 2007 at 9:57 PM

Mark,

Be sure that you have both connection strings set to the proper values. Also if using a SQL Server account, ensure that "TrustedConnection" is NOT listed in your string.

See a few posts above for a simple example of a connection string.

By mitchel.sellers@gmail.com on Wednesday, August 22, 2007 at 3:12 AM

Hello Mitchel,

Just to let you know that it works perfectly! Thank you so much (I find it a little bit more difficult to install it locally than remotely on a shared environment)

For your information, two tips that may help some people:

1/
The connection string for me was the following:
-------------------------------------
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" />
-------------------------------------
It is ABSOLUTELY necessary to modify it this way:
<add name="SiteSqlServer" connectionString="Server=(local);Database=your-database-name;uid=your-login-name;pwd=your-password;" />

2/
You should add a note in your tutorial, to inform people that they should have IIS already installed (otherwise, I run into trouble... This should be put in the first part, to ensure that iis is installed (Add/Remove Windows Components, ...)

Déclic Vidéo FX

By Déclic Vidéo FX on Wednesday, August 22, 2007 at 11:43 PM

But now come the other question...
I would like to copy my database (remote one hosted on SQL Server 2005) locally on my computer... Is there any possibility to do so ? To copy a database (SQL 2005) locally in SQL Express ?

DV FX

By Déclic Vidéo FX on Wednesday, August 22, 2007 at 11:45 PM

DV FX,

Yes you can do that, as long as your production database is under the 4Gb size limitation of SQL Server Express.

My restore tutorial should explain everything for you, but basically you just need to request the .bak file from your hosting provider, then do the restore, ensuring that you overwrite the existing database and specify the proper file locations.

I do this on a weekly basis with my db for this site.

By mitchel.sellers@gmail.com on Thursday, August 23, 2007 at 3:34 AM

I was having the the following problems;
When i went to http://localhost/dotnetnuke455/Install/install.aspx
I either got, the under construction page or the message saying it could not connect to the database, with the provided information.

I tested my connection through the computer Data Sources (ODBC) connection and it work fine.
I try every option for the "Server=***" section in the connection string and it still didn't work.

<SOLUTION>(For me)

I replace my connection string from
"Server=(local);Database=DotNetNuke455;Uid=dnnUser;Pwd=***;"
TO
"Server=nameofserver.domain.com;Database=DotNetNuke455;Uid=dnnUser;Pwd=***;"
I changed the server name to the fully qualified name for the server. After this it worked fine.

Hope It Helps.

By wcopenhaver on Friday, August 24, 2007 at 2:45 PM

I still can NOT get it working under Windows 2003 Server....: "The page cannot be found, HTTP Error 404 - File or directory not found."
But... i can get it working under Windows XP Pro ! I had some error's, but they where solved easily:
"Create failed for login 'dnnuser'. Additional information:
An exception occurred while executing a Transact-SQL statement or batch.
The MUST_CHANGE option is not supported by this version of Microsoft Windows." (has to do with the security policy) and i had: "Server Error in '/DNN' Application.
The current identity (VMWARE\ASPNET) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'."
These are error's with an logic message, so easily to solve.
I must notice that it took a realy LONG time before the module gave its install log file.
(Installing DotNetNuke
Version: 04.05.05
Installation Status Report
00:00:00.031 - Installing Version: 4.4.0)

BUT, the problem with IIS under XP Pro is that it is limited to 10 concurrent connections.....

Still frustrated that i cannot get it working under 2003 server....

By aadhoog on Sunday, August 26, 2007 at 10:21 AM

aad..

Please post in the forums for assistance!

By mitchel.sellers@gmail.com on Sunday, August 26, 2007 at 7:32 PM

hi,
i've installed dotnetnuke 4.5.5 by refering to your notes. when i debug, the page is displayed successfully. however when i try to access using localhost (http://localhost/....) it didn't work. hope anybody can help me... tq

By ecah on Monday, August 27, 2007 at 7:26 PM

hi,
i've installed dotnetnuke 4.5.5 by refering to your notes. when i debug, the page is displayed successfully. however when i try to access using localhost (http://localhost/....) the page cannot display. hope anybody can help me... tq

By ecah on Monday, August 27, 2007 at 7:28 PM

My guess is that when you are debugging you are using the Cassini built in webserver. You will then need to add another portal alias in for just localhost.

SO, when debugging, login as host and add a portal alias for your localhost without the port number. This is under Admin -> Site Settings

By mitchel.sellers@gmail.com on Monday, August 27, 2007 at 9:47 PM

Hi
I just downloaded 4.5.5 (XP pro & IIS) and followed the instructions to a T and got "This site is unavailable. Please try later." After going through the posts here to no avail I decided to take a look at Install.aspx. I put a breakpoint on the private InstallApplication method and ran the site. I went to the Install.aspx page and the stepped through the code from there. Voila! the install completed and I'm looking at the portal! I don't know if it has to do with IIS or not as the only difference was the ASP.NET developer server that ships with VS 2005. I hope this helps someone! :)

By Reeni on Friday, August 31, 2007 at 5:07 AM

Reeni,

The one thing I noticed with IIS is that for one reason or another at times it is taking two calls to the install.aspx page to actually get the install going.... I still have not figured out why.

By mitchel.sellers@gmail.com on Friday, August 31, 2007 at 5:47 AM

I just wanted to say thank you and all of you who give for free they knowloedge, time and effort for us newbies.

Thx, the world keeps on moving due to you all

By Rohirrim on Thursday, September 06, 2007 at 2:28 PM

Hi Thanks for the walkthrough guide. I'm having some trouble with Windows Vista, IIS 7.0 and SQL 2005, i'm keep getting the error in iE that "HTTP 500 internal Server Error" .. IIs7 making me confused ... :[ any idea bro? thanks in advance

By Ruhani on Monday, September 10, 2007 at 6:39 AM

Ensure that your virtual directory is set to use the "Classic" application pool.

By mitchel.sellers@gmail.com on Monday, September 10, 2007 at 4:22 PM

Hey Mitchell, your article helped me a lot. Thanks

By rypki on Sunday, September 16, 2007 at 12:03 AM

another note.
i folowed this step by step, and readed all comments but mi problem was not resolved (site not avaliable and then stored procedure dos not exist).

I finally got DNN working by enabling named pipes on network configuration (Start->Programs->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration manager)
and then run /Install/install.aspx in order to generate database (Database must exist first)

there's a lot of details missing in this step by step (i used my experience in windows servers to get alog this, a regular user could not resolve this by it's own), but it gives a starting point.

Thanks Mitchel.

By delm on Sunday, September 16, 2007 at 4:55 PM

Delm,

Yes, in your case there was some additional setup needed, I guess this article is really designed towards users with a properly configured base install of SQL Server (Express) and IIS. If there are configuration/setup items needed there I don't cover them here.

By mitchel.sellers@gmail.com on Sunday, September 16, 2007 at 7:07 PM

Hi,
I've been trying for 2 days to install dnn now i get this message:
Error Installing DotNetNuke
Current Assembly Version: 04.05.05
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

My connection string is:
<connectionStrings>
<add
name="SiteSqlServer"
connectionString="server=GENESIS\SQLEXPRESS;database=DotNetNuke455;uid=sqladmin;pwd=***;"
providerName="System.Data.SqlClient" />

I'm assuming that i have connected to the SQL server okay but not the database.

Is this assumption correct?
Any suggestions for what to check?
thanks in advance

By steve b on Monday, September 17, 2007 at 5:27 AM

I started SSMSE and tried logging in using SQL server authenticartion and using the same username pwd as in connection string and i get this error message:
TITLE: Connect to Server
------------------------------

Cannot connect to GENESIS\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

By steve b on Monday, September 17, 2007 at 5:33 AM

I'd really like some help with this so here's some more info.
I reinstalled SQL server
i suspect that the latest version has switched something off that is needed here's what it says after installing sql server:
Configuring and Managing SQL Server Express
· For improved manageability and security, SQL Server 2005 provides more control over the SQL Server surface area on your system. To minimize the surface area, the following default configurations have been applied to your instance of SQL server:

o TCP/IP connections are disabled
o Named Pipes is disabled
o SQL Browser must be started manually
o OPENROWSET and OPENDATASOURCE have been disabled
o CLR integration is disabled
o OLE automation is disabled
o xp_cmdshell is disabled

To enable or disable features and services, run the SQL Server Surface Area Configuration tool from the Start menu.

· To install SQL Server Management Studio Express Edition, download it from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).

By steve b on Monday, September 17, 2007 at 6:27 AM

Steve,

If you enable named pipes from the configuration section, or TCP/IP connections you should then be set to go!

By mitchel.sellers@gmail.com on Monday, September 17, 2007 at 6:47 AM

I deleted the database and install directory and downloaded the install utility 4.1.1 from dotnetnuke.com site using windows authentication it installed first time and is now working.
http://www.dotnetnuke.com/Products/Development/Projects/UtilityInstaller/Downloads/tabid/871/Default.aspx

Don't know why 4.5.5 wouldn't work for me but i gave it a good try.
I'll play with this for a while before attempting an upgrade.
please tell me the upgrade path from 4.1.1 is a lot easier.
I would rather pay someone a $100- for an install utility that worked first time with 4.5.5.
i wasted to much time with this install.
I'm wondering if having apache running on my first attempt may of been a problem.
steve

By steve b on Tuesday, September 18, 2007 at 4:56 PM

Hello everybody,
I went this morning completely through the video tutorial and it helped me a lot.
My previous error 500 and other errors are solved yet.
I am trying to install DNN on a Vista machine and I have installed the 4.5.5 version.

My next error is this one:

Error Installing DotNetNuke
Current Assembly Version: 04.05.05
ERROR: Could not connect to database specified in connectionString for SqlDataProvider

SO, it must have to do with my web.config where I have changed the connection string and the application settings as follows:

<connectionStrings>
<add
name="SiteSqlServer"
connectionString="server=PC-VAN-KEES\SQLEXPRESS;Database=DotNetNuke;uid=Kees;pwd=*******;"
providerName="System.Data.SqlClient" />

</connectionStrings>
<appSettings>
<add key="SiteSqlServer" value="Server=PC-VAN-KEES\SQLEXPRESS;Database=DotNetNuke;uid=Kees;pwd=********;"/>
<add key="InstallTemplate" value="DotNetNuke.install.config" />
<add key="AutoUpgrade" value="false" />
<add key="UseInstallWizard" value="false"/>
<add key="InstallMemberRole" value="true" />
<add key="ShowMissingKeys" value="false" />
<add key="EnableWebFarmSupport" value="false" />
<add key="EnableCachePersistence" value="false"/>
<add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
<add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login and registration screens-->
<add key="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
</appSettings>

Please! Who has any further suggestions?

By KeesH on Saturday, September 22, 2007 at 1:22 AM

I would validate that you have the proper database server, database name, username and password values. Also validate that the user does have permission to the database.

The overall format of your strings looks correct.

By mitchel.sellers@gmail.com on Saturday, September 22, 2007 at 4:12 AM

Hi Mitchell,

All the web.config settings were OKE.
The problem was the initial setup with SQLServer 2005 Express.
The mixed mode authentication for Windows AND SQLServer does the trick
!

By KeesH on Sunday, September 23, 2007 at 11:06 PM

Okay, heres the deal:
I installed DNN once succesfully on a local computer, after struggling with it for a while. then i accidentally deleted the folder containing the DNN files. So i tried re-installing it. I delted the database, re-created it and repeated the virtual directory creation, unzipped the install files in the virtual directory, and proceded to grant necessary permissions to the folder. Also modified the config file to put the connection string

the thing is, now, the application doesnt start!!!!!!!

Basically this is what i get:

Server Error in '/nuke_roms' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The code subdirectory '/nuke_roms/App_Code/HTML/' does not exist.

Source Error:

Line 101: -->
Line 102: <codeSubDirectories>
Line 103: <add directoryName="HTML" />
Line 104: <add directoryName="Reports" />
Line 105: <add directoryName="Survey" />


Source File: c:\inetpub\wwwroot\web.config Line: 103


Ive repeated the process a dozen of time, but each time i get the same damned error page.

Any idea of where i went wrong?

By Chris on Monday, October 22, 2007 at 3:07 AM

Chris,

Simply remove line 103 from your config file.

By mitchel.sellers@gmail.com on Monday, October 22, 2007 at 3:46 AM

been there done that :S
I mean i removed the line 103 from the config file, but it reports it to the following lines eg
it tells me error at line 104 and that directory was not found

By Chris on Monday, October 22, 2007 at 9:02 PM

Chris,

For an out of the box DNN Installation that entire section should be commented out or shouldn't exist.

Try removing the entire <codeSubdirectories> section

By mitchel.sellers@gmail.com on Tuesday, October 23, 2007 at 4:28 AM

I have tried for over 7 days to install DNN 4.06 and nothing but errors. Mostly those connections strings issues. I have given up for a while and looking at other open source CMS portals. Any suggentions? Other open source applications such as PHP are not as difficult. I have installed joomla by following their instructions and I was online and working. Moodle was another PHP open source I got going with apache and it worked. I just wanted to see how asp.net is like and I've gotten errors after errors with forum of people indicating their own way of somehow getting it to work or as in my case never getting to work. There should be one way and it should work. Like Steve B said back in September. An Installer problem would greatly help. It should also work if you follow the manual. But I have to remember that its open source and theres a risk if you take it to a production environment. Good luck everyone. It sure takes up a lot of people's time just to get it to work. I have never had problems like this on some PHP open sources that I experiement with. I am taking a breaking for a while then I'll come back to this sql connection string error again. This shouldn't be this hard. After all they claim its easy to get up and running. I haven't experience this and I see many of you here as well as the DNN forum are experiencing this.
Oh, can DNN v4.x.x connect to a "MYSQL"

By Brian Craig on Thursday, October 25, 2007 at 7:11 AM

It says it installed but im getting the following:

The website declined to show this webpage
HTTP 403
Most likely causes:
This website requires you to log in.

I have permissions set and have recreated the Virtual Directory to make the directory path is correct.

By tguerrero on Thursday, January 31, 2008 at 11:16 AM

Hi Mitchel,

I really want to know how to Install DNN 4.5.5 using the Source... I hope you could help me...
Thanks in advance... :)

By zykesian on Thursday, January 31, 2008 at 4:31 PM

Bryan,

The process is similar, but the virtual directory will be the "Website" folder rather than the root folder.

If you want detailed help please use the forum to ask for assistance.

By mitchel.sellers@gmail.com on Thursday, January 31, 2008 at 4:36 PM

okay.. thanks..

By zykesian on Thursday, January 31, 2008 at 4:38 PM

Hi Mithel,

I still have some questions:
1. I already unzip the Source inside Dotnetnuke folder on wwwroot. There's no web.config file?
2. How Can I run the Installation?

By zykesian on Thursday, January 31, 2008 at 5:06 PM

You will need to rename release.config to web.config and use it to configure the site.

By mitchel.sellers@gmail.com on Friday, February 01, 2008 at 6:15 AM

This was an excellent tutorial and helped me to get DDN4.8 running under IIS. However, can you suggest some best practices for developing? What i mean i need to create a new website and would like to use DDN as the starting point.
Let's say the website will be called ACME Portal.
Typically, for every new project i create a new folder under my local machine in a dev area, such as D:\Projects\ACME Portal.

1. Do i now install DDN under here as a starting point? or should i follow the steps you listed and still install under c:\wwwroot\ but instead of naming my sql database DotNetNuke455 and website ddn455, i can use something like acme_db and acme_online?
2. If i keep everything under c:\wwwroot, i would be loading the project in VS2005 from that location. Is that advisable?

basically I’m looking for best practices for developing a website using DDN as the starting point/framework

By Mike on Friday, February 22, 2008 at 7:08 PM

Here's what I've learned so far to get DNN 4.8 installed. I have one or two more issues before it is working but got through several issues. I'm using a VM for SqlServer 2005, and another 2003 Server Standard VM for Studio 2008 and the web server.

Try this to get it working (not in any order)
1. When installing SqlServer 2005, it installs with the network turned OFF. Turn on TCP/IP in SqlServer Configuration Manager.
2. Accessing SqlServer 2005 Express requires putting a ".\" in front of the DB name. i.e. .\mydatabase
3. If the dot net framework was installed prior to turning on IIS, then the framework must be manually registered. aspnet_iisreg -i fixes that issue.
4. In 2003 Server scripts are disabled. I added localhost as a trusted site to fix this. There may be a better way but that is what I did.
5. Must create a blank database or the install won't work. Don't need to do anything else except database->new
6. 2003 server R2 must run Medium trust. Had to use development.config instead of release.config as the starting point for the web.config file.

Now what happens is the site installs and builds out all the database tables. Then when I click the web server goes to 100% utilization and it looks like every 5 seconds it refreshes the page. No errors and IE7 is blank saying "Website found. Waiting for reply..."

John

By John Lehew on Friday, February 22, 2008 at 9:49 PM

Mike,

I see that you migrated your question to the forum, I'll respond there.

Regarding the next post with the issues after install. Validate that the portal alias stored in the PortalAlias table does NOT have a / at the end.

By mitchel.sellers@gmail.com on Saturday, February 23, 2008 at 7:34 AM

hi
i had done all this steps.when i execute it in ie (http://localhost.dotnetnuke) it tell:"the page can not be display"
please help
fery

By fereshteh on Sunday, June 08, 2008 at 5:53 AM

Hi folks.
Was having "Page could not be found" 404 errors while trying to install. Turned out that the problem was with my ASP.NET 2.0.nnnnn had not been configure for use as a web extension in IIS. See following url for problem resolution.
http://office.microsoft.com/en-gb/winsharepointadmin/HA100598511033.aspx

By Geoff Scott on Wednesday, June 11, 2008 at 6:08 PM

I was getting page not found on IIS for dot net 2.0. I installed the IIS using aspnet_regiis -i and it worked fine.

By Manoj on Friday, June 20, 2008 at 12:54 PM

If you are getting This site is currently Unavailable
Please check back later it is because you set the AutoUpgrade = false. Put it back to true or navigate to your portal at http://yoursite/install/install.aspx?mode=install to kick off the installation.

By YoYoDyne on Tuesday, July 22, 2008 at 1:20 PM

Just wanted to mention since I didn't see it that the SQL Server Browser process also needs to be running so the server can accept TCP/IP connections. This is critical if you are not connecting to the server using shared memory.

This held me up for a bit before I remembered shutting down the extra SQL server processes so I could use my box again.

By Jason on Thursday, August 14, 2008 at 11:30 AM

I am trying to install dotNetNuke on my PC. Its Win XP Pro with SP2, IIS 5.1, .NET 2005 and SQL Server 2005.

I followed each and every steps mentioned by you and installation guide. I am getting following error:

"Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. "

However if i run any html file, it runs properly, but gets above error for any ASP file.

Please help me if I am doing something wrong.

The event viewer shows no error.

By csmart on Monday, December 01, 2008 at 12:03 AM

csmart,

Can you please post this to the forum for specific assistance.

The windows Event Viewer should show an application warning at minimum for the error message.

By mitchel.sellers@gmail.com on Monday, December 01, 2008 at 3:03 AM
Click here to post a comment

Donate

Show your appreciation for the content/modules made available by MitchelSellers.com by making a donation. Donations are used to assist with dedicating time to creating free content.