How can you tell it's in focus at night through your viewfinder? Are you focusing on a nice bright point source of light like a street lamp far away? or at you just trying to focus on a dark hillside or something?
Hillside: Your viewfinder probably is just too dark and crappy to focus at night on dark objects. DSLRs aren't meant to do this, and they don't have microprisms and so forth like old manuals did to aid in focusing visually. ESPECIALLY if you're using that lens wide open at f/1.4 You don't stand a snowball's chance in hell at focusing on dark objects at night with the super thin DOF of f/1.4 Not gonna happen, no matter what.
Street lamp, etc.: If you're focusing on a light, then it should be working, and something else is probably wrong. One possibility is that the diopter wheel on your viewfinder is badly adjusted. it's a tiny little wheel next to the viewfinder on most Canons, that moves lenses around to compensate for people who wear eyeglasses. If it's way off, it can make the viewfinder not match the photos very well (like if you have it set for thick glasses, but you don't wear glasses). Try messing around with it during the day with a nice high contrast object, and see if you can adjust it to where the viewfinder agrees with the final image.
The problem is every time I do so and I turn the focus ring as much as I can to let the whole background in focus (it appears so in my viewfinder), the photos turn out unfocused when they take.
Also this is a suspicious comment.
What do you mean by this? If you turn the focus all the way, it shouldn't automatically make everything in focus... It just makes things at "infinity" or close enough to infinity (about 100 feet and beyond at 30mm, f/1.4) in focus.
Look up articles on "depth of field" if you don't know what that means already.
Also look up "hyperfocal distance."