Someone recently told me I could use SQL Server 2008 R2 Express edition for a single website. But don't you need the Server Agent for connections (I think. I'm trying to remember things from over several years ago now!) and Express has it's Server Agent disabled?
You do not need the SQL Server Agent. It has nothing to do with database connectivity.