Bismillah Al-Hamdulillaah wa salatu wa salaamu 'ala rasulullaah
Amma-ba'd
Allaah will surely tear open the sky until He looks at the person from amongst the people of the earth who said it!
There occurs from An-Nisaa'ee (d. 303H), in Amal al-Yawm wal-Laylah, the hadeeth of two men from amongst the companions, from the Prophet (salallaahu 'alayhi wa sallam):
Whoever says, 'Laa illaaha ilallaahu wahdahu la shareekalahu lahul mulku wa lahul hamdu wa Huwa 'ala kulli Shay`in Qadeer' with a sincere heart, attesting to the truth of that with his tongue, then Allaah will surely tear open the sky until He looks at the person from amongst the people of the earth who said it. And the right of the servant whom Allaah looks at is that He grants him whatever he asked for.
Shaikh Al Albaani mentioned 'Isnaadun Saheeh': The hadeeth is mentioned by Ibn Rajab in Kalimatul-Ikhlaas (p. 61)
There also occurs upon the authority of Abu Huraira (radiallahu 'anhu) who said that the Messenger (sallallahu 'alahi wa salam) said:
No servant says 'Laa ilaha illallah' sincerely, except that the heavens open up for it and it ascends until it reaches the throne, providing one stays away from the major sins.
Shaikh Naasir mentioned: 'Isnaadun Hasan' Kalimatul Ikhlaas P.60
Source: Click on the headline or here.