Deploying RS server components on server without MSSQL

For the application I need to integrate RS with, I have a physical server
running MSSQL 2000 SP3a Standard Edition and another physical server that
runs my web apps. Both servers are running windows 2000 SP2. We do not want
to install RS server components on the db server itself because we want it to
remain a dedicated database server.
So, we want to host the Report Server database on the db physical server and
run all of the RS server components on the application physical server.
Yet when I try to install RS on my application server, I get the following
message in the install 'System Prerequisite Check': 'This edition of
Reporting Services does not support installing the server components on this
operating system'. What does this mean? How can I get around it?
-kind regards, Brian ParkerThe issue is not the database. RS is designed to run this way (note that you
need to have another SQL Server license if RS is on another server than
where the DB resides but that is a licensing issue). The issue is the OS.
Here is a link on the prereqs:
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
a.. Windows® 2000 Server with Service Pack 4 (SP4) or later
a.. Windows 2000 Professional with SP4 or later1
I wasn't sure if you had server or professional. If server then it needs
SP4. If professional then this additional info holds:
Windows XP Professional and Windows 2000 Professional only support Reporting
Services Developer Edition
So, one of those two things is what is happening.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian Parker" <BrianParker@.discussions.microsoft.com> wrote in message
news:97ECE792-B9F0-4762-A278-1BC8790797A0@.microsoft.com...
> For the application I need to integrate RS with, I have a physical server
> running MSSQL 2000 SP3a Standard Edition and another physical server that
> runs my web apps. Both servers are running windows 2000 SP2. We do not
> want
> to install RS server components on the db server itself because we want it
> to
> remain a dedicated database server.
> So, we want to host the Report Server database on the db physical server
> and
> run all of the RS server components on the application physical server.
> Yet when I try to install RS on my application server, I get the following
> message in the install 'System Prerequisite Check': 'This edition of
> Reporting Services does not support installing the server components on
> this
> operating system'. What does this mean? How can I get around it?
> -kind regards, Brian Parker

deploy Service pack remotely

How can we deploy SP3a remotely on all our SQL servers ? Is this doable ? Is
there step by step instructions on how to do so and also verify remotely
once completed that it was successful
ThanksI suppose SMS could do this.
You might also try software policies for the Operating System... For
Software policy, that would be doc'c with the operating system and not SQL..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O4Dom6RyDHA.560@.TK2MSFTNGP11.phx.gbl...
> How can we deploy SP3a remotely on all our SQL servers ? Is this doable ?
Is
> there step by step instructions on how to do so and also verify remotely
> once completed that it was successful
> Thanks
>|||By the way, you might also try a login script which runs the setup...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O4Dom6RyDHA.560@.TK2MSFTNGP11.phx.gbl...
> How can we deploy SP3a remotely on all our SQL servers ? Is this doable ?
Is
> there step by step instructions on how to do so and also verify remotely
> once completed that it was successful
> Thanks
>