Hi guys,

I would like to know if this is possible...

I would like to install SSRS in my environment, but because the SQL2005 is hardened (only will allow port  1433), I won't be able to install SSRS in it as I won't be able to access the Report Manager (Web Administration). So I would like to know how can I install the Report Server and Manager on another machine and having it to make use of my existing DB instance to store the ReportServer DB. The reason why i want to do this is so that i wont need to install a new instance of DB in the new machine (where SSRS is). I dont need to worry about licensing as well.

Is it possible for this scenario to happen:

1. Create ReportServer database in my existing Enterprise DB
2. Install ReportManager (which is basically a web folder sitting in IIS i assume) on a new seperate machine
3. Install ReportServer (who does the processing & rendering of report) on the new machine
   or
   Install ReportServer (who does the processing & rendering of report) on the existing Enterprise DB

For step 3, i would like to know what are the implication if i choose either 2?

Whether it's performance issue or the manageability in terms of doing development every now and then

Thanks 

When you install SSRS, Select the "Install but do not configure Reporting Services" option.

After the installation is completed, open Reporting Services Configuration and configure your Reporting Services. You can configure the database, IIS settings etc.

However, if I'm not mistaken, SSRS requires its own DB to function - this can be a separate instance on the machine but I'm not really sure. You may need to check on this.