You'll notice the row of dots across the middle of the frame. These are the lights from a passing airplane. The other lights on the horizon are from cottages on the other side of the lake. The red light on the horizon is not associated with the aurora. The first thing that you need is a dark sky.
Auroras are very faint.
Don't even think about trying to see, let alone photograph one from a city. The second thing you'll need is an aurora. These are usually best seen above the 45th parallel during the winter months. If you're lucky there will be a new moon or a late rising moon. Strong moonlight can completely wash out a faint aurora display.