Where to install ReportServer

Question

I have 2 servers (IIS & SQL). A web site on the IIS server uses the ReportViewer web control. Should ReportServer be installed on the IIS box or the SQL box. (IIS is in the DMZ)

TIA J

Answer 1

You might want to have a look at your license. Typically, if you want to install Reporting Services on a server separate from your SQL server, you must purchase another SQL license. In either case, I would recommend putting your Report Server on the SQL box over your web server.

EDIT: Check here for the specific licensing requirements.

Answer 2

SSRS creates directories in IIS on the machine it is installed on. I would recommend installing SSRS on your SQL instance.