Setup new virtual directory in existing Reporting Services deployment

[Steve]

Hi

We have RS running on a 2005 cluster. So, the dbs are in the clustered
instance and the service runs on each node. We have one application
using the service, which is configured to use the default web site,
ie, the cluster name, in this case //<cluster_name>/reports

I have another application that needs to use reporting services. This
app has it's own web server already. Can I use the reporting services
already running on the cluster, but setup with new virtual directory
on the applications web-server. So, the databases would stay where
they are on the cluster, but the reports would be on a different url,
ie //<new_apps_web_server/reports

When I setup the cluster, I didn't have a suitable web server to
deploy the RS service. I now wish to move away from using the SQL
server as the web server for RS. I expect to have additional apps
wanting to use RS, so want a design that scales up and can be asily
administered. I guess I'm really looking for advice on how to scale
this deployment out.

Hope this makes sense.

[Bruce L-C [MVP]]

Reporting Services definitely can be running on a different server. IF you
want to have multiple RS servers then you need to have enterprise edition
license for each server running RS. Speaking of licensing you need to have a
SQL Server server license (not a CAL) for each server running RS.

I have never performed this before but isn't too hard.

Essentially you can follow this:
http://support.microsoft.com/kb/842425

It points you in the right directly. Be sure to save your encryption key.

When you install RS on the new server you have the option to install and
configure later. That is what you want to do because you don't want it to
create any databases like a default install would. Then when configuring you
point it to the old database. Make sure you apply any service packs to the
new install so they are on the same version of SQL Server exactly.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Steve" <elste...@googlemail.com> wrote in message
news:a9140441-2b59-4ef2...@j19g2000yqk.googlegroups.com...

[Steve]

Thanks, Bruce. That helps.

What was confusing me was how the 3 elements interact.

So we have the 2 databases, the Reporting Services Windows service and
IIS. If I have the lot on one server, A, can I setup virtual
directories on a second server B, while leaving the dbs and windows
service on A. Can you then also install Reporting Services on server C
and still use the original dbs on A.

I see from the article how I move the databases, so it seems like I
should be able to do the reverse of leaving them in place and migratig
the other components.

As an aside, I found the documentation for RS less easy to work
through than some other areas of SQL Server, so your help is
appreciated.

On 16 Nov, 17:46, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com>
wrote:

> Reporting Services definitely can be running on a different server. IF you
> want to have multiple RS servers then you need to have enterprise edition
> license for each server running RS. Speaking of licensing you need to have a
> SQL Server server license (not a CAL) for each server running RS.
>
> I have never performed this before but isn't too hard.
>
> Essentially you can follow this:http://support.microsoft.com/kb/842425
>
> It points you in the right directly. Be sure to save your encryption key.
>
> When you install RS on the new server you have the option to install and
> configure later. That is what you want to do because you don't want it to
> create any databases like a default install would. Then when configuring you
> point it to the old database. Make sure you apply any service packs to the
> new install so they are on the same version of SQL Server exactly.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>

> "Steve" <elsteves...@googlemail.com> wrote in message

>
> news:a9140441-2b59-4ef2...@j19g2000yqk.googlegroups.com...
>
>
>
> > Hi
>
> > We have RS running on a 2005 cluster. So, the dbs are in the clustered
> > instance and the service runs on each node. We have one application
> > using the service, which is configured to use the default web site,
> > ie, the cluster name, in this case //<cluster_name>/reports
>
> > I have another application that needs to use reporting services. This
> > app has it's own web server already. Can I use the reporting services
> > already running on the cluster, but setup with new virtual directory
> > on the applications web-server. So, the databases would stay where
> > they are on the cluster, but the reports would be on a different url,
> > ie //<new_apps_web_server/reports
>
> > When I setup the cluster, I didn't have a suitable web server to
> > deploy the RS service. I now wish to move away from using the SQL
> > server as the web server for RS. I expect to have additional apps
> > wanting to use RS, so want a design that scales up and can be asily
> > administered. I guess I'm really looking for advice on how to scale
> > this deployment out.
>

> > Hope this makes sense.- Hide quoted text -
>
> - Show quoted text -