Hi everyone,
I managed to get it sorted out by disabling the raid functions in the bios. For some reason I didn't think of doing that before. After it managed to startup again only then Windows update reported that the update was successful. I however decided to install the driver package from Nvidia website.
Vista is now however not reporting my Nforce 4 SATA controller anymore. I will have to look into that still.
Thanks for the help guys
