Usually you can turn this on on your messaging app. Simply open you messaging app and open its settings. Should find it there.
Or try this: Press the Home Key> Menu Key> Customization > Tap Notification ringtone > Scroll through the list and select the ringtone you want to use > Tap OK.
Let me know if any works. :)