I have exactly the same problem which happened a few minutes ago!  In this case, the reason the pages were all set to the Home page is the user thought they were specifying where the user is sent after performing the specified action.  I.e., "after login send the user to the home page".

Suggestions will be greatly appreciated!  I would start examining the database directly but I see that SQL Server Express doesn't seem to include any tools for manipulating data.

Thank you for your reply but I wasn't able to see what was relevant.  The thread I found was titled "very very urgent error in DNN:TEXTEDITOR" and I didn't see how the script was relevant (yes, I am new to all of this - I come from the Unix/Linux world).

I have found a script which ought to help at
http://blogs.snapsis.com/PermaLink,guid,05e0a045-4944-4f85-aa12-ac9cb774e2fb.aspx
but when I tried to run it I got an error:

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source File: c:\inetpub\wwwroot\Admin\Users\Password.ascx    Line: 29
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I'm running DNN 4.3.1

I am now trying to access the database directly and have installed "SQL Server Management Studio Express" to talk to the instance of "SQL Server Express Edition" I have running.

However, I am finding that when I connect the only database I can see are the system databases.  I don't see how to connect as the same user as the web server is so I can see the same database (the one used for DNN).

When I try to connect I get:

Server Type: Database Engine
Server Name: PRFORUM\SQLExpress
Authentication: Windows Authentication
User name: GAIA\taylor

The user name is greyed out so I can't change it.  I've really run out of ideas right now.