Yes, you can. Just launch the app and then tap the More options icon at the upper-right portion of the screen. Choose Settings and select Notifications. Tap Notification categories, General notifications and tap Sound. Now you can choose the sound you want to use as notification tone for the default SMS app.