They definitely have the different meaning.
a successful story is describing the story itself.It means the story is good, well-known, or wins some prizes.
a success story means the topic of the story is about some kind of success in some area or study.