I guess my phone is faulty then as i have tried a cable multiple times and i would say 1 in 100 times it actually recognised the phone but couldn't install the drivers for it. The rest of the time it says USB Device has malfunctioned.
Tried all possible thing including different operating systems, different USB ports, different driver and software versions. If i could get it recognised everytime i would have a better chance at getting the drivers installed!
Do have backup of your phone data & PC registries then
Uninstall Nokia PC Suite, Nokia Connectivity cable driver, PC Connectivity solution, Nokia flashing cable driver(if any on your PC), Run PC Suite cleaner. Install latest Nokia PC Suite from europe.nokia.com/pcsuite, reboot your pc. Once pc started, connect your phone with USB in different ports of your PC and check