Last post Feb 06, 2006 09:44 PM by dcurry
Feb 04, 2006 11:39 PM|DanBall|LINK
I was looking over my installation, trying to figure out some glitches, when I realized that the database showing in Enterprise Manager for wasn't even being used. While trouble-shooting this a bit further, I detached the database and DNN is still running!
So, can anyone explain this? I'm suspecting it has to do with SQL Server 2005 Express being installed on the web server, and I'm attempting to view it by using Enterprise Manager in SQL Server 2000.
Feb 05, 2006 03:09 AM|smehaffie|LINK
Feb 05, 2006 09:30 PM|DanBall|LINK
Okay, further investigation shows that both MSDE and SQL Server Express 2005 are installed on that computer. I wasn't aware they could co-exist.
So, that explains why the DNN database doesn't show up in Enterprise Manager, and won't allow me to attach it. I'll have to see if I can uninstall MSDE...
Feb 05, 2006 11:13 PM|christoc|LINK
Feb 06, 2006 03:42 AM|Jean-Marie|LINK
You can download the SQL Server Management Studio Express (free and separate download at following URL, middle of page) to manage SQL Server Express:
Hope this helps.
Feb 06, 2006 08:44 AM|DanBall|LINK
Thanks, I must have missed that optional download. I have the full version of SQL Server 2005 on order, but until that comes this program might suffice.
However, I loaded up that program, and the DNN database STILL doesn't show up... I went to attach it, and just like with Enterprise Manager, it wouldn't let me do it because it was "currently in use".
Feb 06, 2006 12:22 PM|Jean-Marie|LINK
Connecting to a sql server express database engine and viewing/working with its databases and
attaching a database are two different things.
Connecting with Management Studio Tutorial:
Hope this helps.
Feb 06, 2006 12:45 PM|DanBall|LINK
I appreciate the help, it's going to take some getting used to this new management utility...
I followed the instructions step-by-step, and it showed me the same thing I had before. The basic databases (master, model, msdb, tempdb) all show up, but NOT the DNN database... This is indeed odd.
Since the SQL server is running, I then attempt to "attach" to the database, like we used to in SQL 2000. That is when it tells me it cannot because it is in use by another process.
So, I'm at a loss of what to do here, DNN is up and running, using that database (default settings in web.config), but I cannot access it or see it all like the older versions of DNN.
I have the sneaking suspicion that this might be a related problem to my other issues...
Feb 06, 2006 09:44 PM|dcurry|LINK