Are you talking about the Home Basic or the Home Premium of Vista?
I did not have this problem with mine own version (Vista Home Premium) when I upgraded from SP 1.
IS SP 1 installed? SP2 will not install with out it. To see is it is go to start, right click on computer, go to properties. Look at the top. It should list your OS and if installed the Service Pack. If none are listed then you must install Service Pack one to get SP2 to work.
You can try the downloads at this link: http://support.microsoft.com/kb/935791#Method3
It will provide the downloads for both Service Packs.
I hopes that this helps!
Manmur
Hi all, a friend is using Vista Home Edition on a HP Laptop and has tried to download Service pack 2, but keeps getting the same message "Failed" We have downloaded the hot fix key and run that, but still no joy. All the other updates are coming down, but not the Sevice Pack 2. Anyone else had this problem?
Many thanks.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic