In Contacts, under Message Alert. The music file has to be in your Ringtones folder. (If you need it somewhere else, like Alarms, you'll need 2 copies of the file (or a symlink, if you understand what that is - please don't ask for a lesson in Linux here).