It is narrated from Sayyiduna Abdullah bin Abbas (may Allah be pleased with them both) that he said: "Intoxication is one of the major sins." All the narrators of the chain of this narration are thiqat (trustworthy).
It is narrated from Sayyiduna Talq (may Allah be pleased with him): "We were sitting in the gathering of the Prophet of Allah (peace and blessings be upon him) when Suhar of the tribe of Abd al-Qays came and said: O Messenger of Allah! What do you say about a drink that we prepare in our land from our fruits? He (peace and blessings be upon him) turned away from him (paid no attention) until he had asked this same question three times. Then the Prophet (peace and blessings be upon him) stood up and prayed. When he (peace and blessings be upon him) had finished the prayer, he asked: 'Where is the one who asked about the intoxicant? O you who asked about the intoxicant! Do not drink it yourself, nor give any Muslim to drink. So, by the One in whose Hand is the soul of Muhammad (peace and blessings be upon him)! Whoever drinks it seeking the pleasure of its intoxication, Allah Almighty will give him wine (of Hell) to drink on the Day of Resurrection.'" This chain is sahih (authentic) on the condition of Imam Ibn Hibban, and Imam Ahmad bin Hanbal also recorded it.
It is narrated from Sayyiduna Talq bin Ali (may Allah be pleased with him) that "We were sitting in the noble presence of the Prophet (peace and blessings be upon him) (after that incident) when the delegation of the tribe of Abd al-Qays arrived. He (peace and blessings be upon him) (seeing their physical condition) asked: 'What has happened to you, that your complexions have turned yellow, your bellies have swollen and your veins are standing out?' They submitted: 'Our chief came to you and asked you about a drink that suited us, but you forbade him from it, whereas we live in a land that is exposed to epidemic diseases and whose climate is extremely unwholesome.' At this he (peace and blessings be upon him) said: 'Then drink whatever is pure for you.' Imam Muhammad says that what is meant by this is the drink that is lawful." This chain is da'if (weak) because one of its narrators, Ajibah bin Abd al-Hamid, is majhul (unknown).
It is narrated from Sayyiduna Ibn Abbas (may Allah be pleased with them both) that the Messenger of Allah (peace and blessings be upon him) said: "Whoever drinks something until the intellect that Allah Almighty gave him is gone has indeed committed one (great) door among the doors of the major sins." This chain is da'if (weak) because of the weakness of Hanash, whose name is Husayn bin Qays al-Rahabi.