Go to Settings/Sound & Notification/Advanced/Notifications/Messages, Tap on Incoming SMS/MMS and then under sound, you can change the SMS/MMS notification different from the default notification sound. You can do this again for an app or process that is listed under the advanced list.