Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...installation wizard throws error, DB tables still createdinstallation wizard throws error, DB tables still created
Previous
 
Next
New Post
8/8/2012 5:35 PM
 
softize


Joined: 8/5/2012
Posts: 33

Trying manual install of DNN 6.2.2 Community Edition. Got the installation wizard running, it even finds the database and then it only throws this message:

Installing Database - Version 06.00.00...FAILURE ERROR: See C:\inetpub\wwwroot\dnn\Providers\DataProviders\SqlDataProvider\06.00.00.log.resources for more information

But that logfile doesn't exist! And that first (06.00.00) bunch of TSQL statements seem to have been executed, because the database contains lots of tables and some views. So instead of crashing with that useless errormessage, the wizard should just continue with the other scripts (06.00.01...and so on), but it doesn't:(

Web-Installer is not an option, because it's relying on the sql express, while I do have a mssql2008r2 standard and want to use that one.

Here's my environment and what I have tried so far (always with the same result): Using DefaultAppPool or a self-created one, setting it to .net 2.0 or 4.0, using a seperate SQL login (mapped as dbo) or just the "sa", creating the empty DB as collation "Latin1_General_CI_AS" or "Latin1_General_CS_AS",...nothing helps:(  Server is a Win2008R2 64-Bit standard english. SQL is a mssql2008r2 64-bit standard english. Would appreciate any help to get that thing running... And yes, I unblocked the downloaded zip before extracting it;) 
 
New Post
8/8/2012 5:44 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594

Please check if you enabled the dbOwner for the db user you have create for your database, and check the standard schema of the db user who connect to the database.

Be sure you have full permissions for the application pool user, you have set both connection strings on the web.config file, and you have set your standard database schema as your databaseOwner on your web.config file.

Also be sure your IISUsers have read permission.

 

Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
8/8/2012 6:18 PM
 
softize


Joined: 8/5/2012
Posts: 33
Matthias Schlomann wrote:

Please check if you enabled the dbOwner for the db user you have create for your database, and check the standard schema of the db user who connect to the database.

--> Checked. The SQL user is mapped to that DB and is db_owner of that DB and has the role-schema "dbo" for that DB.

Be sure you have full permissions for the application pool user,

--> Checked. (actually not "full permission", but "modify" - as described in all those video-tutorials)

you have set both connection strings on the web.config file,

--> Do I have to set these manually in the web.config before starting the installation wizard?

and you have set your standard database schema as your databaseOwner on your web.config file.

--> I didn't understand that one. Could you please explain? My SQL user is "dnnusr" and he is dbo of the DB named "DNNDB".

Also be sure your IISUsers have read permission.

--> Checked.

 

 Thanks for the hints. Still same error, unfortunately (see my comments above).
 
New Post
8/9/2012 11:46 AM
 
softize


Joined: 8/5/2012
Posts: 33

Ok. Found a logfile in that folder, found some errors of TSQL-Scripts not being able to create some stored procedures (like "invalid column name"...). So I completely uninstalled SQL (Full version) and then installed DNN through the web platform installer. Now DNN works, but I only have sqlexpress. I noticed it also installed the "SQL Server Replication" feature (while my sql full version has been installed without it, maybe that was my initial problem? does DNN need the sql server replication feature?).

I had to install SQL Management Studio Express manually, went ok. But now I miss the "SQL Reporting Services". Is there a way to upgrade this sqlexpress edition to "my" SQL Standard Edition now? (even if it will keep the instance name "SQLEXPRESS") and add the "SQL Reporting Services" then? Or is there a way to add the SQL Reporting Services to this now existing sqlexpress instance?

Thanks in advance.
 
New Post
8/9/2012 8:16 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594

SQL Replication service is not needed for DNN. 

As I know it is posible to upgrade the exypress instance to a higher instance using the upgrade feature of the SQL Server install Wizard.  Basicly I think the Full version wasn't configured right, or there was any missed on the web.config file.  I know of some issues on DNN 6.2.x with missing databaseOwner proberties  on the T-SQL scripts.  Bit this makes only issues if you don't use dbo as the standard Schema of your database Login.

Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...installation wizard throws error, DB tables still createdinstallation wizard throws error, DB tables still created


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