The governor of Connecticut declared a state of emergency in the wake of all the damage as at least two people have been killed in the flooding.