Urgent Solution to Installation

  • Hi,

    I need a solution as to how and where I have to Install Reporting Services.

    I have 3 servers.

    Server 1 is the web server which is has public access.

    Server 2 is the backend sql server which is behind firewall.

    Server 3 is backend server with IIS behind firewall.

    I have developed reports which should be open to public.

    My web application resides is server 1 which has hyperlinks to reports.My backend is in Server 2.

    Where should I install Reporting Services so that Public can access the reports.

    This is very urgent as all the reports are ready It should go into production this week.

    Thank You.

     


    thanx...,

    SSM

  • This depends on whether you want to shell out for another SQL Server License or not. Installing Reporting Services on your existing SQL Server will avoid that. Installing it on any of the other servers will require that you purchase an additional license.

    As for making the reports available on the Internet, quickest option would be to use the ReportViewer control that is part of the samples.

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply