SQL Server Reporting Services and IIS 6.0

Tushar,

You need a SQL Server (licensed) in order to install Reporting Services. You can then deploy reports to this report server that access data on any other location, regardless of type - Oracle, SQL Server, Access, Excel etc etc.

This is a SQL Server instance, it can be on the same or different hardware to the data source.

Jonathan

Hi Tushar,

It's like Jonathan says. You only need more than one instance of Reporting Services if you have different networks or something really dramatic like that. But one instance can consume data from many sources.

You define a Reporting Services DataSource for each SQL instance (or non SQL source of data) you need to access. Then when you create each DataSet, which are typically used for the dropdown lists for report parameters and for the main report queries themselves, you say which DataSource to use. It's very flexible.

I'm not sure if you can have two instances of Reporting Services but I can't think why you would need that. Reporting Services can use different data sources for different reports and is not limited to one database or even one server's databases. You can control access to individual reports or 'folders' of reports so two groups of users would see very different things. I'm pretty confident you can provide reports on different data sources for different groups of users all with one instance.

Hi David,

Thanks for the promt reply....can you elaborate more on this..

Say..

I have 2 db instances inst1 and inst2 on the same windows 2003 (64-bit) server...with separate databases under each of them... then is it possible to have reporting services installed for inst1 and provide reports for the db's under both inst1 and inst2 using the same reporting services and iis 6.0???

Please reply at u'r earliest and thanks in advance!!

Regards, Tushar