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 ...Clean install of 4.4.0 gives exceptionClean install of 4.4.0 gives exception
Previous
 
Next
New Post
12/27/2006 5:00 PM
 
I am not sure, if the ddladmin has sufficient permission to create objects, please refer to the documentation.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/28/2006 12:07 AM
 

OK.  I've done some investigating.  My installation stopped at the same spot as Mihai's - Configuring Super User.

I was puzzled as well since when I look at the database after running the install, I see tables created and some are populated with install data.  I also see that the tables with the ASPNET_ prefix are owned by dbo as opposed to the rest of the tables which are owned by my database user provided by my host.

In my web.config file, I use that same database owner in both of the connection strings.  I know this is correct because I get connected to the database and create and modify objects.

I also changed the parameter for databaseOwner from 'dbo' to the same database user name provided by my host.

My host runs SQL2000 and the ASPNET_ tables are created directly inside the DNN database.  Those are the ones that are created as owned by dbo.

Since the install chokes when it's trying to configure the super user, I assume that it's trying to add data to the .net user data (ASPNET_ tables I assume) and chokes because the tables are owned by dbo and not the user you specify as databaseOwner in web.Config.

So my question is:
At what point in the install are the aspnet_ tables created and can they be created owned by the host-provided database user specified in databaseOwner?  Or is there some other parameter that I'm missing where you can specify a database username other than dbo for tasks like this?

 
New Post
12/29/2006 6:00 AM
 
AFAIK the ASPNET_* tables have always been created as DBO owned w/o issues - this is done by the Microsoft script, and as you all know, Microsoft never produces errors ;)

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/29/2006 11:53 PM
 

I believe that this is definitely the problem.  After much complaining, my host granted my database user db_owner access to my database.  After that the installation ran without generating any errors.  Then I had them set the permissions back to those they give to a standard user, wiped out the db and installed again.  Sure enough, same error at the same point.  When I looked at my db, it was apparent that the install choked at the same point - trying to set up the host user in the aspnet_ tables.  Set it back to db_owner again just to make sure and it worked again.

So the point here is, I guess, that you have to check with your host to make sure that you have a database user with db_owner priveliges if you want to install or update DNN.  It's not enough to have an account that provides access to MSSQL.  You must also find out if you will be granted the appropriate permissions.

The only other alternative is to find out where in the install process the aspnet_ tables are created.  When you start out, you have a completely blank database.  When you're done, you have DNN and aspnet_ tables in there.  I would find it strange if there was no way to change this.  After all, it is possible to have an MSSQL database without a user named dbo (another username with dbo privleges).  In this case would the install fail too?  Any thoughts?

 
New Post
1/5/2007 8:46 AM
 

I still can't solve my problem. The provider does not want to give dbo_owner so i can't install 4.4.0 :(

 

Mihai

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Clean install of 4.4.0 gives exceptionClean install of 4.4.0 gives exception


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