Showing posts with label apache. Show all posts
Showing posts with label apache. Show all posts

Sunday, February 12, 2012

Apache and SQL Reporting Services

Hi Everyone,
I'm pretty new to reporting services so this might be a dumb question.... A client of mine has asked me to use reporting services to create reports for them but they have apache web servers!!!! Is this even possible? I've seen tons of documentation on reporting services by now but none that says you can use it with Apache? The Apache servers all have .NET 1.1 installed and working but I'm not sure if that's enough to get this working.
Any information you could provide me with would be greatly appreciated...... I want to give my client an educated response to this request and I haven't been able to find much!!
THANKS!!!
PJ

Hi PJ,

The simple reply is you will need IIS installed. RS is not compatible to have Apache instead of IIS.

|||Thanks Brad!! I thought I would get this answer (and I like IIS better anyway so I'm not complaining)!
Thanks Again!
PJ

Apache and Reporting Services

Can Reporting Servers run on Apache?No. It is an ASP.Net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1127394777.321200.26010@.g43g2000cwa.googlegroups.com...
> Can Reporting Servers run on Apache?
>|||Sort of. Not truely as 'on' Apache, but if your front-end web server is
Apache, and you want to forward certain requests to be handled by reporting
services, then yes, you can make it LOOK as if it came from Apache itself
using Apache's Reverse Proxy functionality.
You'll need to have the Proxy module, and the Rewrite module compiled into
Apache, then set up a section in httpd.conf that looks like the following,
assuming your Report Server is named "RepServ" and is running on Port 80:
RewriteRule ^/ReportServer(.*) http://RepServ/ReportServer$1 [P,NC]
ProxyPassReverse /ReportServer http://RepServ/ReportServer
This way, when Apache sees requests for anything going to a 'ReportServer'
directory, it will reverse-proxy the request to the report server (Along
with everything else on the URL string - that's what the weird (.*) and $1
parts are for.), the report server will generate the report, and return it
to the Apache server (Thinking that the Apache server is just another web
browser), then Apache will send the report to the actual user, making it
look as if it came from the Apache server.
It's all smoke and mirrors :)
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:1127394777.321200.26010@.g43g2000cwa.googlegroups.com...
> Can Reporting Servers run on Apache?
>|||Hi Bryan,
you might have some trouble getting support for running RS on apache
too.. ;-)
Peter|||I agree, it appears more hassle than it's worth.
--
Regards
<<<Bryan Avery>>
"Peter Nolan" wrote:
> Hi Bryan,
> you might have some trouble getting support for running RS on apache
> too.. ;-)
> Peter
>