On Amazon Web Services what is the difference between SQL Server Standard and SQL Server Web?
Solution 1:
Standard has more roles, like Domain Controller, File Server and all sorts of other enterprise roles. Web has only Web Server, DNS etc, which is good for web hosting. Web is much cheaper, because is designed for scale-up, were you dont need a CAL for each visitor accessing the server via internet, while for the File Server in standard, you pay for each domain user or domain PC.