I recently ran into a problem with a clients system where navigating to a new page cause the system to kick the user back out to the Login page. A couple of pages could be navigated to, but most would kick you out to the Login page.
After some digging I found that the event log was producing an error log on the server of:
Faulting Application name: w3wp.exe , version 7.5.7601.17514 time stamp 0x4ce7a5f8
Faulting module name ntdll.dll, version 6.1.7601.17725, time stamp 0x4ec49b8f
I could not figure out this behavior until I realized the problem was that when navigating to certain pages that did not yet have any user preferences in the VFS, the system was attempting to insert values for the default settings for the page. It was at this time the error occurred and the user was taken back to the login page.
The problem turned out to be that the auto-increment flag had been turned on for the VIRTUALFIELSYSTEM table in the SECTABLEDEFS table. The Key ID for this table is not a normal SLX table ID but is a GUID type. Having the auto-increment turned on was crashing the whole system.
Running the following SQL statement fixed the problem:
update sectabledefs set autoincrement=’F’ where tablename=’virtualfilesystem’