Jailbroken iPhone users can set SMS alert tone on their device but you cannot customize it on non-jailbroken iPhone. So if you want to have it, jailbreak your iPhone device firstly. Second thing that you need before making customization of SMS alert tone is OpenSSH that should be installed over your iPhone. Navigate to Cydia