I have gone through;
- all sound & notification related settings
- the 'Apps' page of settings
- the settings of the messaging app
and I have basically pottered about in the settings options in general to see anything I thought might be related.
I've also done a web search.