Does SQL Server need to be installed on the web-server? Niha October 03, 2017 14:23 Follow Not necessarily. SQL Server can be installed on a separate machine and it is the recommended configuration. Related articles I created a custom user on my SQL server for EP. Which permissions should this user have on SQL server for EP to work? Really Quick Start When I click "Test Connection" button, "Connection Failed" message is displayed I run the setup and it tells me I need IIS and ASP.NET. What are these, and how do I get them? Downloading and Installing Your Upgrade Files