Originally Posted by GuitarG20
I believe the setting for SMS ringtone is in settings in the SMS app itself.
right... you can set a default notification sound in the system settings. then in each app you can set them as well, either specifying "default" or a specific one. Most SMS apps also let you specify a specific notification per contact as well.