Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Reportin Services for a Cluster

Author  Topic 

junior.carls
Starting Member

7 Posts

Posted - 2009-01-28 : 10:37:02
Hi All,

I have a question about deployment of Reporting Services. I am fairly new to SQL Server (comming from the Oracle world), so please forgive my ignorance. We are running a High Availability SQL cluster. We want to deploy reporting services, but I am concerned about reports being published from the cluster. If I understand it correctly, IIS is mandatory for the deployment of Reporting Services. Is it possible to have IIS deployed on a separate physical machine so that reports are published from this machine and not directly from the cluster (of course, the data would still need to come from the cluster).

Thanks in advance,
Dave

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-28 : 12:49:23
i think its possible for reporting server to take data from database engine which it has remote access.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-28 : 13:42:19
Yes that is possible and is the recommendation. What you have described is what we have in production. We put RS on the web server and then the RS databases are on the cluster plus the database that the reports access are on the cluster.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -