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
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...view the tables and data in the DNN database?view the tables and data in the DNN database?
Previous
 
Next
New Post
6/20/2006 5:06 AM
 
Baronne Mouton

Joined: 6/16/2006
Posts: 9

I've just installed a nice new shiny DNN 4.3.0 - I'm using SQL Server Express 2005. I guess this might be more of a SQL server question than DNN.. but anyway - here goes:

Where can I view the data / tables etc. in SQL Server Express 2005. I have logged on to the database server and using the Management Studio Express all I seem to be able to see are System tables... I would have expected to see a bunch of tables relating to the content, users, etc. in there. Any ideas? Am I looking in the wrong place?

cheers

Baronne
 
New Post
6/20/2006 7:15 AM
 
Chris Smith


www.nddllc.com
Joined: 1/25/2003
Posts: 681
Not having used Management Studio Express before, I would imagine that it is much like the full blow application. With that said, under the System Database directory, should be the list User DB's. If it's not presernt, make sure that your logged in to the correct instance of SQLExpress (you can check this under the Object Explorer\browse for more.)
 
New Post
6/20/2006 7:28 AM
 
Baronne Mouton

Joined: 6/16/2006
Posts: 9

Hi Chris,

thanks for the reply. I think you're right it is a lot like the full blown SQL Manager. I do in fact have the dotnetnuke user DB under the system database, but my problem is that if you click on the tables within the dotnetnuke database, all I see there are system tables (and only one entry called sysdiagrams)...  shouldn't all the DNN tables be here?

Baronne
 
New Post
6/20/2006 9:28 AM
 
Chris Smith


www.nddllc.com
Joined: 1/25/2003
Posts: 681
Now that sounds like a credentials issue. Who is the database owner? Did you use an object_qualifier for the DNN setup in the Web.config. What login are you using to access SQL DB?
Provided you're not using "Integrated Security (aka- Network Service)", try using that account to access the DB through the Management Studio. Also, under Security\Logins, see if the "sa" account is enabled (if it's not it should have a little red arrow next to the icon.). After enabling it, try logging in as 'sa'.
 
New Post
6/21/2006 3:54 AM
 
Baronne Mouton

Joined: 6/16/2006
Posts: 9

Hi Chris,

Yeah, I had a sneaky feeling it might have been the security issue. So I have now enabled the 'sa' account - initially I couldn't logon as this account, and now I can after changing the server mode to SQL Server and Windows Authentication. I logged on as SA and still I don't see any tables under the dotnetnuke database.  So this made me think... I logged in as the same account I setup in the web.config and this account actually popped up a message saying the password had expired......... after logging in I still couldn't see the tables.

Now with the password changed on the very account that my dotnetnuke site uses, I logged on to the site and it loaded..... how strange?!!? where is it getting this data form... I looked in the dotnetnuke folders on my server and there's an App_Data folder which seems to be where the data is coming from - there's a few .mdf and .ldf files in there....

how odd... how did that happen I wonder.... ? perhaps it uses that if it can't access SQL server on install??

what do you reckon?

baronne
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...view the tables and data in the DNN database?view the tables and data in the DNN database?


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