DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
  • Search Forums
    Advanced Search
Prev
Next
Forums Development and Extensions SQL and SQL Server

Can't find DNN database with SQL Server Management Studio

 5 Replies
 3 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Author
Messages
MarSim
New Around Here
Posts: 2
New Around Here
6/9/2020 12:22 PM

I am a total newbie with DNN. I installed DNN 9.6.1 on my local Windows PC 3 days ago and have only had one major issue. Every morning I attempt to login to my DNN site using the user name "host" and I'm told the password is incorrect. I am certain the password is correct and I have made no changes to the host account or password. So (1): Why is the host password being reset every night?

I researched how to add a new superuser by registering a new user and then changing the superuser flag in the SQLExpress database. But when I attempt to access the database using SQL Management Studio I can't find a DNN database. In the Databases folder I have "System Databases" and "Database Snapshots".   In "Databases>System Databases>" I have "Master",  "model", "msdb" and "tempdb". None of those DB's contain the DNN tables. So (2) How can I access the DNN database using SQL Management Studio?

My web.config file has the following connection string:

<!-- Connection String for SQL Server 2008/2012 Express -->
 name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
Sebastian Leupold
Veteran Member
Posts: 546
Veteran Member
MVP
MVP
You're an MVP!
6/9/2020 12:49 PM
Password shouldn't be reset automatically, that sounds weird.
You are using a non-attached database file, residing in /app_data subfolder of your website.
If you open this file in Management Studio (SSMS), it will get attached to the SQL server and cannot be accessed by DNN using the connection string above. You will either need to "detach" the database in SSMS afterwards or need to specify server name, database name, create a user and provide credentials in your connection string.
To Update your password, you need to follow these instructions: https://www.betterhostrev...n-host-password.html
Joe Craig
Veteran Member
Posts: 1246
Veteran Member
MVP
MVP
You're an MVP!
6/9/2020 1:59 PM
As you are new to DNN, I'd like to point out that nvQuickSite is a very good tool for installing DNN and creating websites in a standard way. It also creates the database as a SQL Server database.

Oh, the better way to create a new superuser is to create a user using the Users PB page, and then make that user a superuser via the UI.

Recommendateio: until you have some familiarity with DNN, stay away from database modifications using SQL Server. You create less pain that way.
Sebastian Leupold
Veteran Member
Posts: 546
Veteran Member
MVP
MVP
You're an MVP!
6/9/2020 2:10 PM
Joe, it is difficult to use UI, if you can't login.
in this case, he needs to modify values in the database.
However, it might be easier to start DNN installation from scratch using NVQuicksite.
Michael Tobisch
Veteran Member
Posts: 1182
Veteran Member
MVP
MVP
You're an MVP!
6/10/2020 8:31 AM

I guess that you have a database file that is not attached in your SQL Server. What you could do is:

  1. stop the Application Pool
  2. move the Database.mdf file (and maybe the and Database.ldf file as well when it is there) from your App_Data directory to your SQL Server data directory (or directories when you have data files and log files on different hard disks)
  3. attach the database in SQL Server Management Studio
  4. adjust the connection string
  5. Start the application pool

Or start the installation from scratch - create a database before you start, assign the (dbowner) permissions to the app pool and select the database in the installation process (or use nvQuickSite).

Happy DNNing!
Michael

Michael Tobisch
DNN★MVP

DNN Connect
1
liked by Members
Joe Craig
Veteran Member
Posts: 1246
Veteran Member
MVP
MVP
You're an MVP!
6/10/2020 4:16 PM
I agree, In fact, it is nearly impossible to login if the site site was set up with the hashed password format.

Is it's new, I would recommend restarting and using nvQuicksite to do the install.

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. 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.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved