Install RS - Separate DB from Web

I am trying to install reporting services on a web server, which will connect
to an existing instance of the RS Sql Server backend on another machine.
This backend server already has SP2 installed - so when I install RS on the
web server machine and try to point to the existing backend during
installation, it tells me that it is not compatible.
What would be the correct steps to take in order to install on a web server
and connect to an existing RS backend DB? Any relevant articles will help...
Enjoy!
mikeFirst, are you implementing a web farm?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
>I am trying to install reporting services on a web server, which will
>connect
> to an existing instance of the RS Sql Server backend on another machine.
> This backend server already has SP2 installed - so when I install RS on
> the
> web server machine and try to point to the existing backend during
> installation, it tells me that it is not compatible.
> What would be the correct steps to take in order to install on a web
> server
> and connect to an existing RS backend DB? Any relevant articles will
> help...
> Enjoy!
> mike|||Not in the sense that I will have multiple ReportServer databases. I will
have a one to one relationship: 1 web server and 1 server with the
ReportServer database.
It was recommended that I do this by the server admins, in order to take the
load off of IIS.
"Bruce L-C [MVP]" wrote:
> First, are you implementing a web farm?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
> news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
> >I am trying to install reporting services on a web server, which will
> >connect
> > to an existing instance of the RS Sql Server backend on another machine.
> > This backend server already has SP2 installed - so when I install RS on
> > the
> > web server machine and try to point to the existing backend during
> > installation, it tells me that it is not compatible.
> >
> > What would be the correct steps to take in order to install on a web
> > server
> > and connect to an existing RS backend DB? Any relevant articles will
> > help...
> >
> > Enjoy!
> >
> > mike
>
>|||I would try this:
1) install SQL RS on the web server, and during the install, create new
SQL RS database(s) for it to point to / use (doesn't matter where you
put the DB, you'll end up dropping them soon). At the end of the
install, you'll have a new SQL RS web app, pointing to a new SQL RS db.
2) Apply SP1 to the SQL RS instance (web & new database).
3) Apply SP2 to the SQL RS instance (web & new database).
4) Now that you're web app is up to SP2, you can point it to your
original database using the 'rsconfig' command line utility (see SQL RS
Books Online for details of usage & syntax). After using 'rsconfig' to
point your app to the original database, you'll need to run the
'rskeymgmt' command line utility to initialize / activate your Report
Server for use with the original database (allows it to read the
original database) -- see Books Online for details of syntax and usage.
5) Drop the new SQL RS databases that were created in Step #1, since
you're not going to use them, now that your web app is pointing to the
'original' SP2 database.

Install Question

Hello, if my company owns 6 processor licenses for Sql Server, am I able to
utilize Reporting Services or is their a separate license?Whether you need another license depends if you are installing RS on a box
that has SQL Server DB installed on it. You need a license for the box which
has RS installed. For instance, let's say I have a web farm with 3 IIS
servers all of which are using a single DB on another box. I need an
additional 3 SQL Server server licenses.
On the other hand, if I have IIS and RS running on the same box as SQL
Server DB, then RS falls under the license for the DB.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
> Hello, if my company owns 6 processor licenses for Sql Server, am I able
> to
> utilize Reporting Services or is their a separate license?|||Right, so if I split out RS onto a different box, I am ok as long as I have a
license to cover it. So right now if we have 6 enterprise licenses, i could
farm it out over two boxes if desired?
"Bruce L-C [MVP]" wrote:
> Whether you need another license depends if you are installing RS on a box
> that has SQL Server DB installed on it. You need a license for the box which
> has RS installed. For instance, let's say I have a web farm with 3 IIS
> servers all of which are using a single DB on another box. I need an
> additional 3 SQL Server server licenses.
> On the other hand, if I have IIS and RS running on the same box as SQL
> Server DB, then RS falls under the license for the DB.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tcs" <tcs@.discussions.microsoft.com> wrote in message
> news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
> > Hello, if my company owns 6 processor licenses for Sql Server, am I able
> > to
> > utilize Reporting Services or is their a separate license?
>
>|||Definitely. What are you are talking about is a web farm. Several IIS
servers all using the same database for its object caching and metadata
storage. This is an enterprise feature. You need to have a SQL Server
Enterprise license for each IIS box that is running Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:DFA03ABE-38AE-4CD3-B681-7535DF67A8DB@.microsoft.com...
> Right, so if I split out RS onto a different box, I am ok as long as I
> have a
> license to cover it. So right now if we have 6 enterprise licenses, i
> could
> farm it out over two boxes if desired?
>
> "Bruce L-C [MVP]" wrote:
>> Whether you need another license depends if you are installing RS on a
>> box
>> that has SQL Server DB installed on it. You need a license for the box
>> which
>> has RS installed. For instance, let's say I have a web farm with 3 IIS
>> servers all of which are using a single DB on another box. I need an
>> additional 3 SQL Server server licenses.
>> On the other hand, if I have IIS and RS running on the same box as SQL
>> Server DB, then RS falls under the license for the DB.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "tcs" <tcs@.discussions.microsoft.com> wrote in message
>> news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
>> > Hello, if my company owns 6 processor licenses for Sql Server, am I
>> > able
>> > to
>> > utilize Reporting Services or is their a separate license?
>>sql