I used SQL authentication with a NT administrator user which has full rights.
This is the error I saw in the log file but I don't understand what it means:
MSI (s) (28!94) [20:37:32:290]: Closing MSIHANDLE (1728) of type 790531 for thread 1684
MSI (s) (28!94) [20:37:32:478]: Creating MSIHANDLE (1729) of type 790531 for thread 1684
PerfmonLoad routine returned error code 267
MSI (s) (28!94) [20:37:32:478]: Closing MSIHANDLE (1729) of type 790531 for thread 1684
MSI (s) (28:54) [20:37:32:478]: Closing MSIHANDLE (1722) of type 790536 for thread 3756
Now, what a small DBA like me can do with such an error, I don't understand it, but moreover, when I look at the SQL version after the failure I can see that it was upgraded, but, doesn't it rolledback?! well, that is a realy strage situation, and I have checked it on several machines and they all work the same and give the same error.
this is what I did to operate the SP4 upgrade(without the password of course):
C:\SQL2KSP4\MSDE\setup.exe /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD= /Lex C:\MSDELog.log
Aladdin Knowlege Systems