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 ...Can anybody help: Invalid object name Can anybody help: Invalid object name 'dbo.Version'
Previous
 
Next
New Post
7/23/2009 3:40 AM
 
Mischa Boender

Joined: 7/22/2009
Posts: 3

I'm trying to install DNN 5 (latest package). I removed all files from my hosting account and have a clean DB (no existing tables).

I unpacked the ZIP and uploaded it to my account after editing the web.config for the SQL conffiguration (tested the connection string, it's OK).

When browsing to my domain I get the folowing error:

System.Data.SqlClient.SqlException: Invalid object name 'dbo.Version'. at DotNetNuke.Data.SqlDataProvider.GetVersion() at DotNetNuke.Services.Install.InstallWizard.get_DatabaseVersion() at DotNetNuke.Services.Install.InstallWizard.TestDataBaseInstalled() at DotNetNuke.Services.Install.InstallWizard.Initialise() at DotNetNuke.Services.Install.InstallWizard.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 Can anybody help?
 
New Post
7/23/2009 10:37 AM
 
Jeff Cochran


Joined: 6/3/2005
Posts: 2799

Did you create the database?  Give it the required permissions?

Jeff
 
New Post
7/23/2009 3:40 PM
 
Mischa Boender

Joined: 7/22/2009
Posts: 3
Hi Jeff,

The database is hosted, so I only have a database to work with, not a SQL instance. It's hosted on a SQL 2005 server.

I used to have a site running with ASP.NET authentication, I generated (and removed) the tables using Aspnet_regsql.exe with the exact same connection string that's in the DNN web.config.

Regards, Mischa
 
New Post
7/24/2009 9:56 AM
 
Mischa Boender

Joined: 7/22/2009
Posts: 3

 

DNN is running now!!!

I installed a DNN 5 on my Windows 7 machine and used the hosted SQL database (edited the connection strings in web.config), but got the same error. I changed the web.config back to the original one and started the install wizard again. At the step where I had to enter the database details I got the same error again (Invalid object name 'dbo.Version'). So it's the database itself that's causing the trouble.

 

Back to my hosted DNN 5... I tried to run the installer wizard with DBO disabled, but got another error message. The next thing I tried was to use a prefix for the tables... And that worked! Because I wanted to know why I had to use the prefix I removed all tables again and ran the install wizard, but thus time I got the error message from my first post, but this time it read 'dbo.prefixVersion'.

Apparently there is something left in the database after I removed the tables. To install the DNN database again I used another prefix and that worked (again).

Jeff, thanks for your time!
 
New Post
7/11/2010 1:43 AM
 
Guy Lister


cybdyn.com
Joined: 8/11/2005
Posts: 24
The 'dbo.Version' error happened to me when I dropped all the tables in the SQL Server database and tried to reinstall.  To avoid this error (and others) I found that you have to delete all the database objects, views, scalar functions and stored procedures from the database instance before a reinstall.

Here's the script I used:

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

DECLARE @procedureName varchar(500)
DECLARE @objType varchar(2)
DECLARE cur CURSOR
FOR SELECT [name], [type] FROM sys.objects WHERE type in ('p', 'fn', 'v')
OPEN cur

FETCH NEXT FROM cur INTO @procedureName, @objType
WHILE @@fetch_status = 0
BEGIN
if @objType = 'p'
EXEC('DROP PROCEDURE ' + @procedureName)
else if @objType = 'fn'
EXEC('DROP FUNCTION ' + @procedureName)
else if @objType = 'v'
EXEC('DROP VIEW ' + @procedureName)

FETCH NEXT FROM cur INTO @procedureName, @objType
END
CLOSE cur
DEALLOCATE cur
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Can anybody help: Invalid object name Can anybody help: Invalid object name 'dbo.Version'


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