Install DNN 4.0 with SQL Express 2005

Last post 06-16-2006 2:11 AM by mcsrick. 15 replies.

Sort Posts:

  • Install DNN 4.0 with SQL Express 2005

    12-07-2005, 10:54 AM
    • Member
      177 point Member
    • mufahad149
    • Member since 12-06-2005, 3:14 AM
    • Pakistan
    • Posts 35

    Hi,

    Sorry for the late article. I did'nt know how to add screenshots to the article.

    In case of installing with SQL Express 2005 we need to create the SQLExpress database which isn’t provided with the DNN 4.0 installer. This time we’ll use the source in DotNetNuke_4.0.0_Source.zip. Here’s how you can get it to work.

     

    Instructions :-

     

    1.                  Unzip the contents of the zip file DotNetNuke_4.0.0_Source.zip to a physical directory on the file system, say c:/dotnetnuke. This will result as two directories Website, Library and a file DotNetNuke.sln.

     

     

    2.                  Right-click the folder c:/dotnetnuke and click Properties, in the dialog that show up select the Security tab and add a user named NETWORK SERVICE and assign it full access to the folder.

     

     

    3.                  Open the DotNetNuke.sln file with Microsoft Visual Studio 2005. If the VS.NET 2005 prompts the message below, click Yes.

     

     

    4.                  Open the file Mail.vb under the folder Mail in the project DotNetNuke.Library and comment out the line 138 as shown below.

     

     

    5.                  Try to build the solution.

     

     

    6.                  Most probably you’ll get 45 Errors as shown below..... I got them.

     

     

    7.                  To remove these errors if you get them, is easy. Open the ClientAPI.vb file under the project DotNetNuke.WebUtility as shown below and Build the solution once again (OK i know, i know... no time for the details just do it). The build will succeed.

     

     

    8.                  Rename the file release.config under the http://localhost/DotNetNuke_2/ project to web.config as shown below.

     

     

    9.                  Now right-click on the App_Data folder under the http://localhost/DotNetNuke_2/ project, click Add New Item.

     

     

    10.              On the dialog that appears select SQL Database. Let the default name be Database.mdf and click Add.

     

     

    11.              This will add an SQLExpress db named Database.mdf under the App_Code folder.

     

     

    12.              Now open the browser and browse the following url http://localhost/Dotnetnuke_2 . You’ll end up with the error shown below. The reason is that currently you’re running .NET Framework Beta whereas the DNN 4.0 requires .NET Framework 2.0 RTM version. Download the framework from http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en and install it. You might need to uninstall the Beta framework.

     

    13.              After you install the .NET Framework 2.0 you need to configure the virtual directory with Asp.NET 2.0. To do this, open IIS Manager right-click the virtual directory DotNetNuke_2 under the Default Web Site, and select Properties. A dialog appears, select ASP.NET tab and specify the ASP.NET version as 2.0.50727. Click Apply and OK.

     

     

    14.              Now refresh/browse the url http://localhost/Dotnetnuke_2

     

    Hope that helps.

    Muhammad Fahad
    Pakistan
  • Re: Install DNN 4.0 with SQL Express 2005

    12-12-2005, 9:01 AM
    • All-Star
      16,504 point All-Star
    • hooligannes97
    • Member since 09-26-2003, 2:57 PM
    • Bolivia
    • Posts 2,917
    • Moderator

    Useful post muhafad, it would help to edit the images and make them smaller.

    Do you know the truth when you hear it?
  • Re: Install DNN 4.0 with SQL Express 2005

    12-14-2005, 6:12 AM
    • Member
      177 point Member
    • mufahad149
    • Member since 12-06-2005, 3:14 AM
    • Pakistan
    • Posts 35

    Updated the broken images issue.

    In case of installing with SQL Express 2005 we need to create the SQLExpress database which isn’t provided with the DNN 4.0 installer. This time we’ll use the source in DotNetNuke_4.0.0_Source.zip. Here’s how you can get it to work. 

    Instructions :-

    1.                  Unzip the contents of the zip file DotNetNuke_4.0.0_Source.zip to a physical directory on the file system, say c:/dotnetnuke. This will result as two directories Website, Library and a file DotNetNuke.sln.

     

    2.                  Right-click the folder c:/dotnetnuke and click Properties, in the dialog that show up select the Security tab and add a user named NETWORK SERVICE and assign it full access to the folder.

     

     

    3.                  Open the DotNetNuke.sln file with Microsoft Visual Studio 2005. If the VS.NET 2005 prompts the message below, click Yes.

     

     

    4.                  Open the file Mail.vb under the folder Mail in the project DotNetNuke.Library and comment out the line 138 as shown below.

     

     

    5.                  Try to build the solution.

     

     

    6.                  Most probably you’ll get 45 Errors as shown below..... I got them.

     

     

    7.                  To remove these errors if you get them, is easy. Open the ClientAPI.vb file under the project DotNetNuke.WebUtility as shown below and Build the solution once again (OK i know, i know... no time for the details just do it). The build will succeed.

     

     

    8.                  Rename the file release.config under the http://localhost/DotNetNuke_2/ project to web.config as shown below.

     

     

    9.                  Now right-click on the App_Data folder under the http://localhost/DotNetNuke_2/ project, click Add New Item.

     

     

    10.              On the dialog that appears select SQL Database. Let the default name be Database.mdf and click Add.

     

     

    11.              This will add an SQLExpress db named Database.mdf under the App_Code folder.

     

     

    12.              Now open the browser and browse the following url http://localhost/Dotnetnuke_2 . You’ll end up with the error shown below. The reason is that currently you’re running .NET Framework Beta whereas the DNN 4.0 requires .NET Framework 2.0 RTM version. Download the framework from http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en and install it. You might need to uninstall the Beta framework.

     

    13.              After you install the .NET Framework 2.0 you need to configure the virtual directory with Asp.NET 2.0. To do this, open IIS Manager right-click the virtual directory DotNetNuke_2 under the Default Web Site, and select Properties. A dialog appears, select ASP.NET tab and specify the ASP.NET version as 2.0.50727. Click Apply and OK.

     

     14.              Now refresh/browse the url http://localhost/Dotnetnuke_2

    Muhammad Fahad
    Pakistan
  • Re: Install DNN 4.0 with SQL Express 2005

    12-31-2005, 6:17 AM
    • Member
      80 point Member
    • adelinoaraujo
    • Member since 11-30-2004, 7:03 AM
    • Porto Portugal
    • Posts 16

    It helps to know how to setup it up for the intranet and internet too....

    Check my post at http://forums.asp.net/1155707/ShowPost.aspx that jeff answered.

  • Re: Install DNN 4.0 with SQL Express 2005

    12-31-2005, 11:27 AM
    • All-Star
      16,504 point All-Star
    • hooligannes97
    • Member since 09-26-2003, 2:57 PM
    • Bolivia
    • Posts 2,917
    • Moderator
    Hey!!! I thought I answered it... :)
    Do you know the truth when you hear it?
  • Re: Install DNN 4.0 with SQL Express 2005

    12-31-2005, 4:08 PM
    • Member
      80 point Member
    • adelinoaraujo
    • Member since 11-30-2004, 7:03 AM
    • Porto Portugal
    • Posts 16

    Hey! You did!

    But there is one importante detail about those "alias" that keept me from deploy my site. DNN need to know the url name, for localhost or the live site with the domain info. Jeff told me that, so I thought that the info was a "plus" for your amazing post. Lots of detail and images.

    Thanks

  • Re: Install DNN 4.0 with SQL Express 2005

    12-31-2005, 4:15 PM
    • Member
      80 point Member
    • adelinoaraujo
    • Member since 11-30-2004, 7:03 AM
    • Porto Portugal
    • Posts 16
    adelinoaraujo wrote:

    Hey! You did!

    But there is one importante detail about those "alias" that keept me from deploy my site. DNN need to know the url name, for localhost or the live site with the domain info. Jeff told me that, so I thought that the info was a "plus" for your amazing post. Lots of detail and images.

    Thanks

     

    lol user confusion...

  • Re: Install DNN 4.0 with SQL Express 2005

    01-01-2006, 2:21 PM
    • Member
      40 point Member
    • sharnish
    • Member since 10-11-2005, 9:04 AM
    • Posts 9

    Thanks for your helpful post. 

    Am attempting to installing DNN 4.0.2 and have SQL Server 2005 on my local machine.  I use Windows XP SP2 which has a different sharing/security screen than you and the Installation Guide use (you show Win 2000/2003?).  Users available in XP in the MMC Computer Management applet are: 1) my Windows administrator login (sharnish) plus 2) IUSR_<localhost> and 3) ASPNET.  

    A) What adjustments to Users/Permissions are required for installation under Win XP, IIS 5?

    B) How will Users and Permissions need to be adjusted when I upload DNN 4.0.2 to my shared hosting environment?

    Thanks very much.

  • Re: Install DNN 4.0 with SQL Express 2005

    01-01-2006, 2:40 PM
    • Member
      40 point Member
    • sharnish
    • Member since 10-11-2005, 9:04 AM
    • Posts 9
    As a follow-up, the user "ASPNET" is apparently the Windows XP alternative for the Network Services user you specify.  This account is created when ASP.NET is installed.  I have added this user to the DotNetNuke database in SQL Server 2005. The Win XP password for this account cannot be viewed or changed.  Is this the account needed for DNN 4.0.2 and how is the web.config database string set for this user?  Or am I needlessly going around in circles? Thanks again.
  • Re: Install DNN 4.0 with SQL Express 2005

    01-01-2006, 3:39 PM
    • All-Star
      16,504 point All-Star
    • hooligannes97
    • Member since 09-26-2003, 2:57 PM
    • Bolivia
    • Posts 2,917
    • Moderator

    A) Give the ASPNET user Modify permissions to the DNN directory

    B) Depending on the OS at your host you will need to have the same modify permissions to user ASPNET or NETWORK SERVICE

    Do you know the truth when you hear it?
  • Re: Install DNN 4.0 with SQL Express 2005

    01-01-2006, 3:44 PM
    • All-Star
      16,504 point All-Star
    • hooligannes97
    • Member since 09-26-2003, 2:57 PM
    • Bolivia
    • Posts 2,917
    • Moderator

    sharnish wrote:
    As a follow-up, the user "ASPNET" is apparently the Windows XP alternative for the Network Services user you specify.  This account is created when ASP.NET is installed.  I have added this user to the DotNetNuke database in SQL Server 2005. The Win XP password for this account cannot be viewed or changed.  Is this the account needed for DNN 4.0.2 and how is the web.config database string set for this user?  Or am I needlessly going around in circles? Thanks again.

    Depending on your SQL installation use a Windows Account or a SQL Account for the DNN DB . This account is used  by DNN to access the DB and create the tables (Hence the DB_owner requirement). Don't confuse this DB account with the file system account used to give ASPNET permissions to create and manipulate files in the DNN Directory.

    Do you know the truth when you hear it?
  • Re: Install DNN 4.0 with SQL Express 2005

    01-01-2006, 4:13 PM
    • Member
      40 point Member
    • sharnish
    • Member since 10-11-2005, 9:04 AM
    • Posts 9

    "A) Give the ASPNET user Modify permissions to the DNN directory"

    Sorry to be dense, but how do I do this with Win XP?  In the directory's Properties applet in XP there are only 4 tabs: General, Sharing, Web sharing, and Customize.  There is no Security tab as illustrated in the example above.  I see the ASPNET user in Computer Management, but am at a loss at granting permissions to the directory. If I try going through IIS (ver 5) the user available is IUSR_<localhost> using annonymous access.  Do I do it here? Thanks much.

  • Re: Install DNN 4.0 with SQL Express 2005

    01-01-2006, 4:22 PM
    • All-Star
      16,504 point All-Star
    • hooligannes97
    • Member since 09-26-2003, 2:57 PM
    • Bolivia
    • Posts 2,917
    • Moderator

    Please use MSFT KB to search for "Windows XP Permissions" I remember there was a specific set of steps to enable the tab to appear, but don't remember off the top of my head.

    OT and sincere advise. Use search features (here and everywhere else) as much as you can, it is always good to come here at the forums havng done your homework first. Don't take it the wrong way. While members are here to receive and give help, there are things you can and should solve on your own.

    Do you know the truth when you hear it?
  • Re: Install DNN 4.0 with SQL Express 2005

    01-01-2006, 4:51 PM
    • Member
      40 point Member
    • sharnish
    • Member since 10-11-2005, 9:04 AM
    • Posts 9

    That was exactly what I needed to know re XP.

    Rank newbie here, wandering like Moses in the wilderness.

    Thanks.

  • Re: Install DNN 4.0 with SQL Express 2005

    04-11-2006, 6:48 AM
    • Member
      10 point Member
    • raja_parvez
    • Member since 04-04-2006, 1:23 PM
    • Posts 2

    Assalam -alaikum,

    I m a new guy to dotnetnuke,i m trying to installing dotnetnuke,I saw your artical it is very nice.You have a lot of command on dotnetnuke.

                      I m trying to install dotnetnuke 4.0.2 on asp.net 2.0 and sql server 2005 but i m not able to install it and and i also i don`t knw how to add asp.net module to dotnetnuke.

    While installing i m getting error \siteurl.config not found.

    Please help me in solving this proble.

      Allah-Hafiz

    Raja Parvez

    raja_parvez@yahoo.co.in

Page 1 of 2 (16 items) 1 2 Next >