Worked out MSXML got corrupted in the upgrade for some reason. Managed to delete some of the files from System 32 folder and reinstall them and it got a bit further on start-up but still crashed. Ended up doing a full system restore from a backup image.
I am going to try and upgrade to SP2...