How to upgrade Websense from 6.3.1 to 7.1 (MSDE upgrade instance)

Hi I am a Websense Administrator

I am not asking for assistance, I just want to share with the Community the struggle I have overcome recently with a Websense update from 6.3.1 to 7.1

If I had the below information this would have saved me a load of time.

Websense is very easy to install, just grab the software from www.websense.com

it is only difficult if you are upgrading from a previous version of Wsense which utilizes Microsoft’s MSDE 7, as the current latest version from websense (7.1) utilizes MSDE 2000 sp4

so in my case I was required to install the newer Microsoft MSDE 2000a with SP4, and reserve the current Data within the Default Database instance.

I downloaded Microsoft’s MSDE software, if you run the software from windows it will install and Setup a Default Instance with a BLANK password (very secure ) (you can refer to this via services.msc called MSSQL$), now if you already have a default instance running you will receive a error "the instance name specified is invalid"

so here is a summary of the steps I followed which obviously can be applied to any MSDE upgrade.

*Note that Microsoft suggest backing up your Database before trying to upgrade (makes sense)

Upgrade MSDE to SP4

Downloaded these 2 files
MSDE 2000a
http://www.microsoft.com/downloads [...] laylang=en

MSDE 2000 SP4
http://www.microsoft.com/downloads [...] laylang=en
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE


Now first I installed the MSDE 2000a from Run dialog box
<Drive Letter>:\MSDE2000A\Setup.exe INSTANCENAME="Websense" SAWP="SecurePassword"

I do not know if this step was necessary as this only installed a new instance, and did nothing to the default Database which is where websense installs its Database (so now I have MSSQL$ and MSSQL$WEBSENSE) *I think that this was probably a useless step but HEY my systems are working fine now the above step installed another instance of a database called websense, I also assigned a Securepassword to this instance.

MSDE 2000sp4
I decided to throw caution to the wind and run the Upgrade flag (against certain forums suggestions), this made the most sense to me, as this would not require trying to install a new default Instance which already existed, but upgrade it, sounds simple?

Before doing this step I Highly recommend disabling all start-up programs and services utilising MSCONFIG, Start-up (select disable all) under Services selecting all Microsoft services, and disabling all 3rd party Services (HIDE MICROSOFT SERVICES and DISABLE ALL)
Restart the System and ensure that only one Administrator is running before continuing, as I ran into script errors with 2 Admin accounts running at the same time (e.g. multiple remote logins) *Only necessary if you have MSDE installed within windows server environment

From the Run command execute the Following. (just direct this to where you have dropped the setup files)
*this upgrade is directed at the Default instance, this also allows netwo