Good day,

Looking for some clarification on the database used with DNN (4.9.4).  I installed Sql Server Express 2005, following the install guidelines I found on the web, and created a database, named "database.mdf", assigned the approriate rights, etc.  I went into the SQL managemnt tool and the database doesn't seem to contain anything?  I then found a database (called database.mdf under the app_data folder below the root, which seems to be the one DNN is using??  The web.config file uses "AttachDBFilename=|DataDirectory|Database.mdf" within its ConnectionStrings.  How do I know which database its pointing to, and how do I get the management software to be able to open the database.mdf file if thats the correct database so I can check out the stored procedures, tables, etc?

TIA

- Joe

During the install process you would have been asked to supply a specific server and user information for the DB, if you did not the server is something like .\SQLExpress. Can't remember exactly off the top of my head.

If you have not created a bunch of data I would probably suggest starting with a fresh install that will actually connect to the proper DB with the proper user.

This is basically what I did.  There wasn't much work done so I changed the folder the SQLExpress stores its databases in to the APP_DATA folder (to make the web.config connectionstrings easier to write) and re-installed.  Seems to be fine now and I can access the database now.

Thanks for your help!

- Joe