CODEWITHSUNDEEP
iisreportviewerreportserver
John S
John S

Reputation: 8341

Where to install ReportServer

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

Upvotes: 0

Views: 435

Answers (2)

Ta01
Ta01

Reputation: 31620

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

Upvotes: 1

Scott Arrington
Scott Arrington

Reputation: 12503

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.

Upvotes: 0

Related Questions