Deployment Questions

I am planning to install/deploy SQL Reporting Services at our agency.
We have a web server, a SQL Server (Enterprise license), and various
other servers. I know that the RS database has to be installed on a
server with SQL Server 2000 license, but is it also advisable to
install the report server components on the SQL Server box? This would
entail putting IIS on the SQL Server machine, and I'm not sure that
this is a good idea...
Basically, I am looking for "best practices" for a standard deployment
of RS. At this point, we will be running our application over our
local intranet, and will only have about 20 users.Hello Jad,
Just to note. Installing Reporting Services on the same server running SQL
Server 2000 is not a requirement. During Setup, you can choose whether to
create the report server database on a local or remote SQL Server instance.
Take a peek at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8jom.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8k82.asp
Adrian M.
"JAD" <jdevilli@.lasers.state.la.us> wrote in message
news:1106087493.051954.122790@.c13g2000cwb.googlegroups.com...
>I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>|||You can deploy reports just by right click on the project and select
deploying to the desired report server.
Or you can use scripts for deploying reports.
Another method is uploading the rdl on the report server.
The first one is easier but the developer should be an admin of the report
server.
Eralper
http://www.kodyaz.com
"JAD" wrote:
> I am planning to install/deploy SQL Reporting Services at our agency.
> We have a web server, a SQL Server (Enterprise license), and various
> other servers. I know that the RS database has to be installed on a
> server with SQL Server 2000 license, but is it also advisable to
> install the report server components on the SQL Server box? This would
> entail putting IIS on the SQL Server machine, and I'm not sure that
> this is a good idea...
> Basically, I am looking for "best practices" for a standard deployment
> of RS. At this point, we will be running our application over our
> local intranet, and will only have about 20 users.
>