I cant install the reports seerver on the same machine than the database
server. What can I do?
I need database on one server and pages on another server. I just cant open
web server service on the database server.
Please helpme.
Thanks
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/You can definitely do this. If you want multiple web servers then that is
considered a web farm and you need to read up on that. Otherwise there is a
process where you install RS on a different server than where the DB is that
is used by RS. Note that you have to buy a license for this server. It it is
installed on a different machine then you need to purchase a license.
Another thing for you to consider is to install SQL Server on your web
server and use it just for reports. RS uses the DB for object storage,
caching etc. The data you report off of can be anywhere. SQL Server is very
good on not consuming much resources when it is not under load. If you have
a 3/4 of aGig of RAM or more on your webserver I would consider this
approach.
I suggest going here:
http://www.microsoft.com/sql/reporting/
download books on line and search it on the word install
One point to consider (which even more makes it worthwhile to install SQL
Server on the webserver just for its use (no data) is this statement I found
when reading about command line install:
... the SQL Server instance that hosts the report server database. All
editions of Reporting Services require SQL Server 2000 with SP3a or later.
For Standard Edition, the instance of SQL Server must be local. For all
others, it can either be local or available over the network. The servername
portion of the parameter can be a hostname, or an IP address. Reporting
Services does not support MSDE as a SQL Server instance.
So, if you don't have SQL Server running on the same machine you have to buy
an enterprise license rather than standard.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:%23Sf0WsEEFHA.392@.TK2MSFTNGP14.phx.gbl...
> I cant install the reports seerver on the same machine than the database
> server. What can I do?
> I need database on one server and pages on another server. I just cant
open
> web server service on the database server.
> Please helpme.
> Thanks
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment