Where is Database? - Installing DNN Platform

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

Home All Forums

1
2
3
4
5

3/13/2015 8:38 PM

Ax. Wx.

Joined: 10/19/2005

Posts: 57

Where is Database?

I have been away for awhile...I just tried to get my head back into things here and so I downloaded DNN 7.04 and installed it locally. I had set up a DNN login on my local SQLExpress 2014 instance and expected the install to ask me for credentials. To my surprise it just went through and said it was all done. I look at my SQLExpress installation and there is no DB there. I finally tracked down the MDF file, named database.mdf, but when I try to attach to the DB from my mgmt studio instance - it will not attach. What is the deal here? I want to be able to look at the db through that UI. Is it because this is a SQL Express 2012 MDF file and I am using SQL 2014 or ...?

3/14/2015 5:53 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Where is Database?

by Default, DNN uses a User Instance DB during Installation - unless you create a blank database upfront and specify database and Login credentials on the initial install page. You may turn a user instance DB into an attached DB by shutting down DNN, moving the database to the proper SQL Server Folder (where permissions allow SQL Server to Access it) and modify both Connection strings in your web.config file to use an attached DB ("database=xxx;integratedSecurity=true" or "database=xxx;uid=yyy:password=zzz")

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

3/14/2015 5:54 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Where is Database?

PS: if you haven't made many modifications on the site, it might be easiest to restart from scratch :)

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

3/14/2015 11:19 AM

Ax. Wx.

Joined: 10/19/2005

Posts: 57

Re: Where is Database?

If I can just move it that would be fastest, but SQL server did not give an error when I tried to attach, so not sure permissions issue, but I will give it a try

3/14/2015 5:48 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Where is Database?

you can't attach the database file, as long as it is in use by IIS

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)