I briefly discussed this on the ASP.Net forums, but nothing ever really come of it.
How is the SQL Server 2005 Express database "supposed" to work with DNN 4.0.2?
It is up and running, but I could not locate the database in the Enterprise Manager console. I could see all the generic databases, master, model, msdb, tempdb, etc..., but could not see a DotNetNuke database. I attempted to add the database into the console, since I knew where the file was, and it said I could attach it because it was currently in use.
So, I then downloaded the SQL Server Management for Express, and tried that, same thing. I then waited for our new CDs to arrive with the full version of SQL Server 2005, and then tried that console, same thing. I could not add the database in because it was "already in use". Finally, I shut down IIS, and then added the database into the Management Console. I could then view the database as expected, browsing all the tables, etc... But when I started up IIS/DNN again, I could no longer reach the database from the console.
In all the previous versions of DNN, I was always able to view the database in real-time, but now I can't. I don't think this is the way it is "supposed" to be working, it is like it is being opened in exclusive mode or something similar. I also am suspecting that this inability to access the database correctly is the root cause of many of my problems with DNN that I am experiencing.
Does anyone have enough experience with the SQL server to assist me with this? Unfortunately, I don't know it intricately enough to figure this problem out.