Long press on the account > special settings > message notifications. Turn on special settings for the account; enable notifications, pick your sound, LED on/off and color, vibration on/off and pattern.
You don't copy the sound, you point -to- a sound that is already on your device. In the message notifications settings click on sound and go from there.
(You asked the same question in 2015 and again in early 2017)