2 Samuel 7:8-9

“So now, say this to my servant David: ‘This is what the Lord of hosts says: I took you from the pasture and from your work as a shepherd to make you leader of my people Israel.  I was with you wherever you went, and I defeated all your enemies before you. Now I will make you as famous as the great men of the earth.

David wants to build a house for the Lord God on earth (the temple). He suggests this plan to the prophet Nathan, and Nathan immediately gives him the green light to do it. Yet, here we see the Lord speaking with Nathan to correct David's path. The Lord God already had in mind exactly how He planned to have this accomplished, and it was not work that belonged to David, it belonged to Solomon. David has the right heart, a good thing, a go ahead from the prophet Nathan: yet the word from the Lord is "No." The Lord encourages David about their relationship and promises to make him famous, "like the names of the greatest men on earth". God wants to make us great, and it was David's relationship with the Lord that made him great. The same goes for us.