Welcome to the forum. You should try this steps >>
Messaging > Menu button > Settings > Scroll down > Select ringtone (you can put your custom ringtones here by doing the below)
Applications > My files > Media folder > Audio folder > Create a notifications folder if it doesn't exist. (Menu button > Create folder) > Put desired ringtone here.
Enjoy the forum. Happy Holidays.