Was the haunting in Connecticut real?

Not entirely. It was 'based on a true story' and it was 'dramatized' meaning altered to make it a better story.

This and another movie ("A Haunting in Connecticut" in 2002) were based on events that were reported by the Snedeker family. There have been numerous other similar stories.

*See the related link for more information