Jami` at-Tirmidhi, Hadith 2046 ⓘ
Simak narrated that he heard 'Alqamah bin Wa'il narrate from his father, that he witnessed the Prophet (s.a.w) being asked by Suwaid bin Tariq -or Tariq bin Suwaid- about Khamr, and he forbade it. So he said: "We use it as a treatment." So the Messenger of Allah (S.A.W) said: "It is certainly not a treatment, rather, it is a disease."
حَدَّثَنَا مَحْمُودُ بْنُ غَيْلاَنَ، حَدَّثَنَا أَبُو دَاوُدَ، عَنْ شُعْبَةَ، عَنْ سِمَاكٍ، أَنَّهُ سَمِعَ عَلْقَمَةَ بْنَ وَائِلٍ، عَنْ أَبِيهِ، أَنَّهُ شَهِدَ النَّبِيَّ صلى الله عليه وسلم وَسَأَلَهُ سُوَيْدُ بْنُ طَارِقٍ أَوْ طَارِقُ بْنُ سُوَيْدٍ عَنِ الْخَمْرِ فَنَهَاهُ عَنْهُ فَقَالَ إِنَّنَا نَتَدَاوَى بِهَا . فَقَالَ رَسُولُ اللَّهِ صلى الله عليه وسلم " إِنَّهَا لَيْسَتْ بِدَوَاءٍ وَلَكِنَّهَا دَاءٌ " .
also referenced under: Book 28, Hadith 2182 (In-Book) & Volume 4, Book 26, Hadith 2046 (DarusSalam)