As for now there is the possibility to set notification sound for specific contacts, once you are in the SMS panel. It would be great if it would be possible from within the general settings. For example, a setting like "notification bper account" and then you can add the contacts you want to give a specific sound when a message is arriving.