Windows server 2008 web edition with SQL Server (Limits?)
"Remote Desktop Services" is very different to Remote Desktop. Remote desktop (for 2 remote + 1 console users) is available in every Microsoft server OS since Windows 2000. 2k8 Web is no different.
As far as SQL server is concerned, I believe it's technically possible to install SQL Server with a minimum of fuss (For 2005 I believe you'll need SP3). HOWEVER, the big limitation is that the SQL server can only be used by the web server it's installed on. You can't install SQL Server on it and then use that SQL for other applications/servers.