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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics