Does SQL Server need to be installed on the web-server?

Installation & Upgrade
Not necessarily. SQL Server can be installed on a separate machine and it is the recommended configuration.