Deploy Reporting Services to remote IIS
Hello,
I have problem with my SSRS configuration. I have two servers with Windows 2008. One of them is running IIS (host1). The second one has SQL Server 2008 Reporting Services (host2). I would like to use first server to host ReportServer web site. So I've created
simple test site on port 80. Then I started on second machine Reporting Services Configuration Manger, select Web Service Url, then button advanced. I enter as host header name "host1", so url looks like http://host1:80/ReportServer. I get information
that url was successfully reserved. But on host1 server there's no virtual directory created. Is it possible to make such solution? Can I just copy: "C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer" directory
to remote server after configuration, but I'm not sure if it should be done in this way.
Thank you for all suggestions
Regards
Tomasz
November 11th, 2010 5:17pm
Hello,
I have problem with my SSRS configuration. I have two servers with Windows 2008. One of them is running IIS (host1). The second one has SQL Server 2008 Reporting Services (host2). I would like to use first server to host ReportServer web site. So I've created
simple test site on port 80. Then I started on second machine Reporting Services Configuration Manger, select Web Service Url, then button advanced. I enter as host header name "host1", so url looks like http://host1:80/ReportServer. I get information that
url was successfully reserved. But on host1 server there's no virtual directory created. Is it possible to make such solution? Can I just copy: "C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer" directory to remote server
after configuration, but I'm not sure if it should be done in this way.
Thank you for all suggestions
Regards
Tomasz
Hi Tszulczewski,
Reporting Services uses role-based security to grant user access to a report server. On a new report server installation,
only users who are members of the local Administrators group have permissions to deploy the reports to report server. To make this operation available to other users on the host2, you must create role assignments on host1 that map user or group accounts
to a predefined role that specifies a collection of tasks. For more information please click this link to get a detailed steps:
http://msdn.microsoft.com/en-us/library/ms156034.aspx
Thanks,
Challen Fu
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 10:30pm