I need a bit of kindergarten-level help here - I'm stumped. Here's a long-winded history.
I'm only at DNN design and staging, using SQL Server 2005 Express and DNN 4.4.1. I am using a purely local situation, on Windows XP SP2, .NET Framework 2.0, all patches applied to Windows, to .NET, to IE6, to SQL Server 2005 Express, etc. The computer name is XPPRO
I got it working, installed and activated a few modules, made a couple of pages, etc -
then experienced a series of errors (all slightly different, but essentially to do with connection string or inability to connect to the database) a couple of hours later, after doing something rather silly.
Silly thing:
- DNN portal not active. No browser active, no IIS or SQL tools active.
- With the 2 files in place ( c:\dotnetnuke\App_Data\ ) I used SQL Server 2005 Express Management Studio to attach the Database.mdf (and its log).
- In Management Studio, I did see that the database was marked as "In (??something)" in the right-hand pane. Obviously not a healthy state, I thought.
- Decided to just detach, quit Management Studio. ie, no actions done on any tables (not even a query).
Started up DNN with IE6 browser htpp://localhost\dotnetnuke
Result: DNN doesn't load, shows Server error - (?401) - can't connect to database (sorry, didn't preserve or remember this one).
After the first error, I checked database.mdf, database_log.ldf and noticed that they both have the same file time (11:26AM). So, I copied the 2 files to another location.
I had quit DNN, so then zipped up the 2 files and copied the ZIP to another machine (XP120) where I was able to attach and view the database with SQL Server 2005 Express (Management Studio) without problems. That is, the database files aren't damaged.
More recently, errors like this:
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
Cannot open user default database. Login failed. Login failed for user 'XPPRO\ASPNET'.
It's likely that at some time I also changed folder permissions on C:\dotnetnuke\ - that might be my problem. I'm not sure.
What I do see now, in the original location, is that the .mdf file time is several hours later than the log file (which is still at 11:26AM).
Should I move or delete the log file perhaps? Or is this a problem with folder permissions? I have permissions very lax at present (so I can't see that would be a problem).