Does RS require IIS to be on the DB server?

[RRinTetons]

I found a previous thread explaining why Reporting Services requires IIS. Like most folks, I DON'T want IIS running on my database servers, and I don't want to license SQL Server all over again just to avoid it.

Since I'm running an IIS server on another box to support the interface and other services for the application in question why can't I use _that_ IIS server and leave RS on the database server by itself?

Richard Ray
Jackson Hole Mtn Resort

 

[JohnBates]

it seems that it does have to be installed locally.

see my similar post from awhile back in this thread:
javascriptpenindex(450,350,'

http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=350')

John

 

[JohnBates]

well, that was ugly...

find Thread181-27567 in this forum - June 2004

 

[RRinTetons]

Hmmmmmm, that seems to link to a thread on some sort of VB form issues. I did search this forum and found a thread on the topic indicating the need for IIS on the database server, I was just wondering if there had been any further thinking/experience since then.

Sounds like it's still IIS on the DB server - bummer.

Richard Ray
Jackson Hole Mtn Resort

 

[Catadmin]

IIS doesn't need to be installed on the server that SQL itself is on. It needs to be installed on the server that Report Server / Report Manager is on.

To quote the RS BOL: "Connection to SQL Server 2000 SP3a instance." is one of the requirements for the Report Server itself. So, if you could install an ODBC or the SQL Client Tools, you should still be able to get it to work.

Also, Report Designer can be installed on a different machine that the Report Server. That requires Visual Studio .Net and MDAC 2.6 or higher. Again, it just needs a connection to the SQL Server.

Of course, once you go splitting up all those features, MS requires that you have a SQL Server license for each machine, regardless of whether you actually have SQL Server installed on those boxes.

Hope that helps.






Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[Catadmin]

Richard,

Just re-read your post. The reason IIS is required to be on the same machine as the Report Server and Report Manager is because the reports *must* be saved in the default IIS directory in order for people to be able to access them. Unfortunately, MS isn't giving people much of a chance on the licensing issue. Either you put IIS on your DB server so you don't have to re-license RS, or you put RS on the IIS server and have to fork over more money.

MS likes to get their money. @=/

On the other hand, you could test putting RS on the IIS server in your test environment. It'll ask for a valid SQL Server CD key, which you could try putting in the one for your SQL server from the other machine, and see if it actually dings you for that or not...

Believe me, they developed the product this way on purpose.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???