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

Deploying a Reporting Model

I'm trying to deploy a Reporting Model (.rmdl), but it continues to give the
standard error message of "The permissions granted to user <me> are
insufficient for performing this operation".
I am an Administrator on the computer and have given myself every possible
permission in the Reporting Services web UI.
Any ideas?
Thanks,
JustinWell, it took me for-ev-er, but I found the problem.
The "Content Manager" role did not have any of the Report Model permissions
checked. I'm guessing that this is because I upgraded from the SQL 2000
version to 2005 and it was being nice by not giving Content Manager more
permissions than what it already had.
To resolve this problem under "Configure item-level role definitions" click
Content Manager and make sure everything is check. Specifically the "Manage
Models" and "View Models" permissions.
Hope that helps someone out there!
Justin
"Justin" wrote:
> I'm trying to deploy a Reporting Model (.rmdl), but it continues to give the
> standard error message of "The permissions granted to user <me> are
> insufficient for performing this operation".
> I am an Administrator on the computer and have given myself every possible
> permission in the Reporting Services web UI.
> Any ideas?
> Thanks,
> Justin