Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...New DNN Installation - Failure updating DB to 05.02.00New DNN Installation - Failure updating DB to 05.02.00
Previous
 
Next
New Post
8/27/2010 12:39 PM
 
Upon using the installation wizard on the Run Database Installation Scripts page I am presented with a "Failure installing Database Scripts" problem with the following output:

Installing Database - Version 05.00.00...Success
Upgrading Database to Version 05.00.01...Success
Upgrading Database to Version 05.01.00...Success
Upgrading Database to Version 05.01.01...Success
Upgrading Database to Version 05.01.02...Success
Upgrading Database to Version 05.01.03...Success
Upgrading Database to Version 05.01.04...Success
Upgrading Database to Version 05.02.00...FAILURE ERROR: (see 05.02.00.log for more information)


Now if I try to reconnect to the IP where my DNN is installed I'm presented with the following page:

Domain Name Windows Server 2003 Does Not Exist In The Database

DotNetNuke supports multiple portals from a single database/codebase. It accomplishes this by converting the URL of the client browser Request to a valid PortalID in the Portals database table. The following steps describe the process:

  1. Web Server Processing
    • When a web server receives a Request from a client browser, it compares the file name extension on the target URL resource to its Application Extension Mappings defined in IIS.
    • Based on the corresponding match, IIS then sends the Request to the defined Executable Path ( aspnet_asapi.dll in the case of ASP.NET Requests ).
    • The aspnet_isapi.dll engine processes the Request in an ordered series of events beginning with Application_BeginRequest.


  2. HttpModule.URLRewrite OnBeginRequest ( UrlRewriteModule.vb )
    • The Request URL is parsed based on the "/" character
    • A Domain Name is constructed using each of the relevant parsed URL segments.

      Examples:

      URL: http://www.domain.com/default.aspx = Domain Name: www.domain.com
      URL: http://209.75.24.131/default.aspx = Domain Name: 209.75.24.131
      URL: http://localhost/DotNetNuke/default.aspx = Domain Name: localhost/DotNetNuke
      URL: http://www.domain.com/virtualdirectory/default.aspx = Domain Name: www.domain.com/virtualdirectory
      URL: http://www.domain.com/directory/default.aspx = Domain Name: www.domain.com/directory

    • Using the Domain Name, the application queries the database ( Portals table - PortalAlias field ) to locate a matching record.

      Note: If there are multiple URLs which correspond to the same portal then the PortalAlias field must contain each valid Domain Name in a comma seperated list.

      Example:

      URL: http://localhost/DotNetNuke/default.aspx
      URL: http://MACHINENAME/DotNetNuke/default.aspx
      URL: http://209.32.134.65/DotNetNuke/default.aspx
      PortalAlias: localhost/DotNetNuke,MACHINENAME/DotNetNuke,209.32.134.65/DotNetNuke

      Note: If you are installing the application to a remote server you must modify the PortalAlias field value for the default record in the Portals table according to the rules defined above.

I'm running MS Windows Server 2003 Enterprise Editions SP2 on the server w/ my DNN installation and running the same OS on my SQL Server with the following info provided by the ABOUT option in SQL Server 2005 Management studio:
Microsoft SQL Server Management Studio                       9.00.1399.00
Microsoft Analysis Services Client Tools                       2005.090.1399.00
Microsoft Data Access Components (MDAC)                       2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                       2.6 3.0 4.0 6.0
Microsoft Internet Explorer                       8.0.6001.18702
Microsoft .NET Framework                       2.0.50727.3603
Operating System                       5.2.3790


---- the thing is... the PORTALS table doesn't have a PortalAlias field; and when I enter data into the PortalAliases Table with my IP for the DNN installation it says that it doesn't work; I get a red ! and it won't let me save my data in the table.

Help?
 
New Post
8/27/2010 1:22 PM
 
Since the installation failed while executing the database scripts, it is not unexpected that you would not be able to reconnect to the site's url. Anytime an installation fails it is best to delete all of the installation files from the site's root folder and copy the install package's files back into the empty root folder and delete and recreate the database. After resolving the original error try proceeding with the install again.

As for the original error, I'm guessing that it may be related to database server version which for DNN 5.02.00 and above requires MS SQL Server 2005 or 2008 (standard or express).I am not 100% sure based on the information provided that the database server itself is SQL Server 2005 and not SQL Server 2000. It appears that it is from the SSMS version number but it is possible that that version number may refer to SSMS and not the database server. Also, confirm that the database (under general properties in SSMS) is set for compatibility mode 90 rather than 80.

Please inspect the log file: \Providers\DataProviders\SqlDataProvider\05.02.00.log (or 05.02.00.log.resources) for more details of the error.

You will also want to confirm that you are running version 3.5 SP1 of ASP.Net as that is another requirement for DNN 5.02.00 and above (or ASP.Net 4.0 for DNN 5.4.x and above.

Finally, am I correct that you are trying to install the latest DNN version 5.05.00 ?

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
8/27/2010 2:04 PM
 
Okay, I'm not much of a DB guy; i'm a Designer. So this SSMS stuff and checking database versions and setting the compatibility mode is all greek to me. As for your final question; yes.. I am installing the current version of DNN and I do have ASP.NET 4.0 installed as well. The 05.02.00.log.resources file is empty when opened in notepad
 
New Post
8/27/2010 2:10 PM
 
I'm running ASP.net 4.0
Trying to install DNN 5.5
Not sure about anything you said in the second paragraph as i'm not a Database person; I'm only a designer.
My log file is completely empty when opened in notepad.

This has to be at least the 12th time I've attempted an installation of DNN and this is the furthest I've gotten. Every time I re-install i follow your instructions in the first paragraph.
 
New Post
8/28/2010 12:25 AM
 
You may be installing DNN on your home computer, or you may be installing with a web host. Either way, you are using a MSSQL server, the database server from Microsoft or its free copy SQL Express.

There are 3 versions of MSSQL around (each with their own Express version): SQL 2000, SQL 2005 and SQL 2008. Since version 05.02.00, DNN needs SQL 2005 or higher. If you use SQl 2000, you're stuck at DNN 05.01.xx. If you're with a web host, you should check with him about the version of SQL server.

Mind you, DNN works with the Express versions as well as with the full versions

____________________________________
The one-eyed in the land of the blind.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...New DNN Installation - Failure updating DB to 05.02.00New DNN Installation - Failure updating DB to 05.02.00


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out