sql server reporting services: Deploying RS server components on server without MSSQL -- sql server reporting services

Deploying RS server components on server without MSSQL

Brian Parker
1/1/2005 9:05:06 AM

sql server reporting services:

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?

Re: Deploying RS server components on server without MSSQL

Bruce L-C [MVP]
1/1/2005 12:19:21 PM

The 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

[quoted text, click to view]