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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Help with an installationHelp with an installation
Previous
 
Next
New Post
3/16/2009 12:04 PM
 

I get this error on install.  Where might I start looking for the problem?

Installing DotNetNuke

Version: 04.09.02



Installation Status Report

00: - Installing Version: 4.4.0


00: -   Executing Script: DotNetNuke.SetUp.SqlDataProvider 

Success

00:00:00.203 -   Executing Script: DotNetNuke.Schema.SqlDataProvider 

Success

00:00:01.968 -   Executing Script: DotNetNuke.Data.SqlDataProvider 

Success

00:00:03.062 - Installing MemberRole Provider:


00:00:03.062 -   Executing Script: InstallCommon


00:00:03.828 -   Executing Script: InstallMembership


00:00:04.265 -   Executing Script: InstallProfile


00:00:04.531 -   Executing Script: InstallRoles


00:00:04.843 - Upgrading to Version: 4.9.2


00:00:04.843 -   Executing Script: 04.04.01.SqlDataProvider 

Success

00:00:05.281 -   Executing Script: 04.05.00.SqlDataProvider 

Success

00:00:06.109 -   Executing Script: 04.05.01.SqlDataProvider 

Success

00:00:06.390 -   Executing Script: 04.05.02.SqlDataProvider 

Success

00:00:06.750 -   Executing Script: 04.05.03.SqlDataProvider 

Success

00:00:07.140 -   Executing Script: 04.05.04.SqlDataProvider 

Success

00:00:07.375 -   Executing Script: 04.05.05.SqlDataProvider 

Success

00:00:07.640 -   Executing Script: 04.06.00.SqlDataProvider 

Success

00:00:08.234 -   Executing Script: 04.06.01.SqlDataProvider 

Success

00:00:08.515 -   Executing Script: 04.06.02.SqlDataProvider 

Success

00:00:08.687 -   Executing Script: 04.07.00.SqlDataProvider 

Success

00:00:09.078 -   Executing Script: 04.08.00.SqlDataProvider 

Success

00:00:09.312 -   Executing Script: 04.08.01.SqlDataProvider 

Success

00:00:09.609 -   Executing Script: 04.08.02.SqlDataProvider 

Success

00:00:09.796 -   Executing Script: 04.08.03.SqlDataProvider 

Success

00:00:09.984 -   Executing Script: 04.08.04.SqlDataProvider 

Success

00:00:10.187 -   Executing Script: 04.09.00.SqlDataProvider 

Success

00:00:10.703 -   Executing Script: 04.09.01.SqlDataProvider 

Success

00:00:11.078 -   Executing Script: 04.09.02.SqlDataProvider 

Success

00:00:11.359 - Performing General Upgrades


00:00:11.625 - Loading Host Settings:


00:00:11.656 - Configuring SuperUser:


00:00:12.203 - Synchronizing Host Files:


00:00:12.265 - Installing Modules:


00:00:12.265 -   Installing Module File HTML_04.08.01_Install:  

Success

00:00:14.203 -   Installing Module File Links_04.00.01_Install:  

Success

00:00:15.578 - Executing Additional Scripts:


00:00:15.578 -   Creating Portal: Test


00:00:15.718 -   

Error: Error creating Profile Definitions

00:00:15.718 -   

Portal failed to install:Error!

00:00:15.718 - Installing Optional Resources:


00:00:15.718 -   Installing Package File LiveID_01.00.00_Install:  

Success

00:00:16.109 -   Installing Package File OpenID_01.00.00_Install:  

Success



Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)
 
New Post
3/16/2009 8:48 PM
 

Here is some more information:

When running the installation wizard and testing the database connection, I get:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 3701
Message: Cannot drop the procedure 'usrce5a961ca1f6GetDatabaseVersion', because it does not exist or you do not have permission.

 

I think that there should be a "." between the username and the name of the stored procedure.  Where might something be wrong?




Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)
 
New Post
3/16/2009 9:02 PM
 

Is this possibly a bug?

I looked at TestDatabaseConnection() in Install / InstallWizard.aspx.vb.

I added the part that is highlighted, and then the database connection worked and the install proceeded to completion.

Note that I was doing the install with "Run as DB Owner" unchecked.

 

        Private Function TestDatabaseConnection() As Boolean
            Dim success As Boolean = False

            If String.IsNullOrEmpty(rblDatabases.SelectedValue) Then
                connectionString = "ERROR:" + LocalizeString("ChooseDbError")
            Else
                Dim isSQLFile As Boolean = (rblDatabases.SelectedValue = "SQLFile")
                Dim builder As DbConnectionStringBuilder = dataProvider.GetConnectionStringBuilder()
                If Not String.IsNullOrEmpty(txtServer.Text) Then
                    builder("Data Source") = txtServer.Text
                End If
                If Not String.IsNullOrEmpty(txtDatabase.Text) And Not isSQLFile Then
                    builder("Initial Catalog") = txtDatabase.Text
                End If
                If Not String.IsNullOrEmpty(txtFile.Text) And isSQLFile Then
                    builder("attachdbfilename") = "|DataDirectory|" + txtFile.Text
                End If
                If chkIntegrated.Checked Then
                    builder("integrated security") = "true"
                End If
                If Not String.IsNullOrEmpty(txtUserId.Text) Then
                    builder("uid") = txtUserId.Text
                End If
                If Not String.IsNullOrEmpty(txtPassword.Text) Then
                    builder("pwd") = txtPassword.Text
                End If
                If isSQLFile Then
                    builder("user instance") = "true"
                End If

                Dim owner As String = txtUserId.Text + "."
                If chkOwner.Checked Then
                    owner = "dbo."
                End If

                connectionString = dataProvider.Instance.TestDatabaseConnection(builder, owner, txtqualifier.Text)
            End If

            If connectionString.StartsWith("ERROR:") Then
                lblDataBaseError.Text = String.format(LocalizeString("ConnectError"), connectionString.Replace("ERROR:", ""))
            Else
                success = True
                lblDataBaseError.Text = LocalizeString("ConnectSuccess")
            End If
            Return success
        End Function




Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Help with an installationHelp with an installation


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