How are you connecting the piano to the interface?
Your analog chain begins with the audio 1/4 inch output jack* of the piano or speakers if you are using a microphone to record the sound output from the piano and continues into your audio interface until it hits the analog to digital conversion stage in the interface. Once the signal is converted to digital (which is all that Sonar receives) there is no way to increase the signal relative to the noise.
If the output from the piano is not sufficient then you need to increase the gain on the interface. If the output volume control on the piano is not set high enough then just increasing the gain in the interface will also result in recording electrical noise at a high ratio to the audio signal.
*Actually the analog chain includes the internal electronics inside the piano as well--so everything after the digital to analog convertors inside the piano that produce an electrical audio signal that feeds the piano speakers or the analog output jacks.