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 ...Interesting SQL Server 2008 R2 Database issue with a rather cryptic message I canInteresting SQL Server 2008 R2 Database issue with a rather cryptic message I can't figure out
Previous
 
Next
New Post
5/24/2012 11:57 PM
 

Hi all,

If somebody could give me a hand figuring this message out, I'd appreciate it since it is stopping my installation of DNN 6 from working.  After going to configure the databae, I select SQL Server 2005/2008 Database since I have created one, and then after giving the database name, the user (which is also mapped to a login of the same name), and the password, whether run as DB Owner is check or unchecked, I get the following error:

Installing Database - Version 06.00.00...FAILURE 400 - The stored procedure 'DNNUser.UpdateDatabaseVersionAndName' doesn't exist.  What exactly is going on here, and how do I correct the error?  I'm very new to DNn, so any help is very much appreciated.  And for your information, I'm using SQL Server 2008 R2 Express (though I'm not using the auto installation method since I created the database beforehand), IIS 7.5, and Windows Server 2008 R2.  SQl Server 2012 exists on the system, but I'm not using it for this; it is empty. 


 
New Post
5/26/2012 4:36 AM
 
it looks like DNN has an issue to create stored procedures properly. please drop the database and recreate it (as well as assigning the user with dbowner permission)

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/26/2012 10:30 AM
 
okay thanks.  I kind of figured that it was something like that, and that just about seals the inaccessibility coffin for SQL Server, I hate to say.  I'll use T-SQl or PowerShell and see if I can get it right this time.  I'll let you know if anything goes crazy the second time around.  But I appreciate your explanation though.  It helps a nooby like me out.  By the way, is there a place either here or on another site that you know of with a list of DNn's error codes and what corrective action to take when they are seen?  I'm asking because whenever I search on a cryptic error, more often than not, the results I get back are just as or more cryptic than the error LOL.  Thank you so much.      
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Interesting SQL Server 2008 R2 Database issue with a rather cryptic message I canInteresting SQL Server 2008 R2 Database issue with a rather cryptic message I can't figure out


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