Upgrading NAV from 5.0 to SP1 on SQL

FYI.  Do not put your SQL database into single user mode.  What will happen is, during the Technical upgrade (i.e., the client) NAV will go through the motions of setting up all of the appropriate VSIFT views and appear to finish successfully.  However, the last step of the Technical Upgrade is a synchronization of security.  From what I can tell at the moment this looks as if when it synchs your user it temporarily breaks your connection and then tries to reestablish it.  At which point you get the standard SQL error that you cannot log in.  Leaving the DB in multi user mode eliminates this issue.  So, after NAV crashes out and you put it back into multi-user mode and begin the upgrade again you get the next error which is that the VSIFT views already exist.  Simply go into SQL Enterprise Manager and delete all of the previously created views and begin again.  You should have no isses at this point 'unless' your user does not have adequate SQL permissions.  I would suggest a sysadmin do this portion of the upgrade.