Lost database puzzel

Question

I have installed a dotNetNuke web portal application in my localhost root (localhost:dnn1")

I can view the application in browser. It funtions properly, connecting to the database.

This application is driven by a sql database (dnn1).

the connection string , as checked in iis as well as the application web.config addresses /SQLEXPRESS, and "dnn1" using integrated security.

I open sql server management studio 10.50.2500.00 and log into local /sqlexpress.

this is sql server2008rc  express.

I was wanting to modify some tables in "dnn1".

The database is not there. The application is still running through the browser.

I have used search, manually checked default locations such as the sql data folder.

search does not find in on the computer.

there is no other database in the file.

This is a new installation of the managment studio.

I believe the dnn1 was installed with web platform installer which also insalled an earlier version of sql2008 express.

I have looked for the physical file, and just cant seem to find it.

I believe that the upgrade of the database may be the issue.

Thank you

Answer 1

the connection string , as checked in iis as well as the application web.config addresses /SQLEXPRESS, and "dnn1" using integrated security.

Hello,

How does the connection exactly look like? Is there something in like "AttachDatabase..." and "UserInstance=TRUE"?

In the installation folder, is there a folder named APP_DATA with a MDF file in it? If so, the a User Instance is used and the database gets attached during runtime to the user instance of SQL Server; therefore you can't see it when you connect with SSMS to the normal instance.

---

Olaf Helper

Blog Xing