Click the Text Message icon as if you’re going to send a message. On the top right you should see 3 vertical dots. Touch that, then you should see Settings in the list.
Open Settings > Notifications > Notification sounds