Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
The file is in System/Library/Audio/UISounds and I believe the one you are looking for is called connect_power.caf. I use custom sounds all the time I never delete them I just rename like so connect_power.cafXXX
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.