x

SQL Server Reporting Services and IIS 6.0

Hi All,

I am very very new to these SQL concepts. Please don't mind if this is a silly question...but can somebody tell me whether it is possible to host two reporting services (SQL Server 2005) for two diffrent databases on one IIS 6.0 (Windows server 2003 Enterprise Edition)??? If yes how can it be done???

Scenario:- 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 the earliset...thanks in advance!!

Regards, Tushar

more ▼

asked Nov 17, 2009 at 07:10 AM in Default

Tushar gravatar image

Tushar
15 1 1 2

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

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

more ▼

answered Nov 17, 2009 at 12:56 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Nov 18, 2009 at 07:44 AM

David Wimbush gravatar image

David Wimbush
5.2k 29 31 34

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Nov 17, 2009 at 07:37 AM

David Wimbush gravatar image

David Wimbush
5.2k 29 31 34

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Nov 17, 2009 at 08:20 AM

Tushar gravatar image

Tushar
15 1 1 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x561

asked: Nov 17, 2009 at 07:10 AM

Seen: 2372 times

Last Updated: Nov 17, 2009 at 08:31 AM