Posted 28 October 2010 - 04:18 PM
Though i'm not an expert by any means yet since i'm not yet microsoft certified (coming in the near future), I think I might be able to help you out. I've been looking at the specifications for MSSQl Server 2008 Express R2, and it certainly seems like a viable option for you. just as long as your clients aren't constantly accessing it. In fact, microsoft themselves promote the Express versions of MSSQL just for situations like yours. They say "for sharing data over a local network". For you don't seem to have too much going on, so failover doesn't seem to need to be in the cards for you. But just a question, why in the world are you using terminal services? It seems like you've got too small of a network for that. You could just use remote desktop. And to confirm what you said earlier, Microsoft is silly in their assumption that the database server should run on separate hardware isolated from everything else. They follow with the one server, one role, model. You instead need to actually think about your network, and you decide, not Microsoft. It's all about the traffic, not the apps. Hope this helps.
The AccessCop Network is just me and my crew.
Some call me The Queen of Cambridge