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
Where to install ReportServer
434 Views Asked by John S At
2
There are 2 best solutions below
1
On
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.
SSRS creates directories in IIS on the machine it is installed on. I would recommend installing SSRS on your SQL instance.