Video or still, that's a very, very tough exposure especially with most gear. The human eye can resolve far more detail and latitude between the brightest and darkest components than most cameras. Because of that, you probably won't get a quick and easy solution in camera and you must rely on post processing the shot.
Forget automatic settings and go totally manual. Under-expose the scene a bit. Import the program into your editing software and work with color correction. One trick we use in high-level production is to do multiple exposures of a scene and then composite them back together in editing. I've worked on commericals where we had 5 or 6 exposures of a landscape that get combined into one stunning shot. Think HDR for video.
Even with the best gear, it's not an easy shot so drink some eggnog, take your time and have fun.
.
