rs.exe scripts

I'm a SQL Server DBA and will be playing the role of a
SQL2000 Reporting Services administrator. To tightly
control the environment and keep track of all the changes,
I'm considering to implement a policy that requires all
changes to Reporting Services and reports be released into
production via VB.NET scripts for rs.exe, and all such
scripts be submitted to me for review first.
I'd like to bounce this off you guys to see (1) whether
I'm going overboard, and (2) whether all changes can be
implemented via RS scripts.
JoeAs far as your first question, about going overboard... it's not clear to me
how this policy can be enforced. Users could just run any script, or write
their own app to talk to the server. If you really want to prevent users
from performing certain actions, I recommend using the built in security to
give users only the permissions they need for the actions you want them to
take.
As far as functionality... rs.exe has complete access to the SOAP API.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:46ae01c4734b$5b917fa0$a401280a@.phx.gbl...
> I'm a SQL Server DBA and will be playing the role of a
> SQL2000 Reporting Services administrator. To tightly
> control the environment and keep track of all the changes,
> I'm considering to implement a policy that requires all
> changes to Reporting Services and reports be released into
> production via VB.NET scripts for rs.exe, and all such
> scripts be submitted to me for review first.
> I'd like to bounce this off you guys to see (1) whether
> I'm going overboard, and (2) whether all changes can be
> implemented via RS scripts.
> Joe|||Thanks, Brian!
I was thinking in the line of SQL Server's DDL vs DML, if
I can make such a similar distinction in SSRS. So
for 'DDL' type of changes, I'll try to enforce the rs
scripting requirement, whereas for 'DML' type of changes,
the users can make whatever changes however they want.
Just like in SQL Server, the users can
insert/delete/update their data with their permissions,
and I really don't care what they do. But when it comes to
schema changes, I make sure that thye submit scripts to me
first.
Now, can I classify SSRS tasks into 'DDL' and 'DML', and
assign security to allow DML changes only?
Joe
>--Original Message--
>As far as your first question, about going overboard...
it's not clear to me
>how this policy can be enforced. Users could just run
any script, or write
>their own app to talk to the server. If you really want
to prevent users
>from performing certain actions, I recommend using the
built in security to
>give users only the permissions they need for the actions
you want them to
>take.
>As far as functionality... rs.exe has complete access to
the SOAP API.
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights
>"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote
in message
>news:46ae01c4734b$5b917fa0$a401280a@.phx.gbl...
>> I'm a SQL Server DBA and will be playing the role of a
>> SQL2000 Reporting Services administrator. To tightly
>> control the environment and keep track of all the
changes,
>> I'm considering to implement a policy that requires all
>> changes to Reporting Services and reports be released
into
>> production via VB.NET scripts for rs.exe, and all such
>> scripts be submitted to me for review first.
>> I'd like to bounce this off you guys to see (1) whether
>> I'm going overboard, and (2) whether all changes can be
>> implemented via RS scripts.
>> Joe
>
>.
>

RS.exe and executables

I'm currently working on automating the installation of a set of reports to a reports server, using a few scripts run with rs.exe. It works well, however, the overhead of having the scripts compiled and then executed is unacceptable. I'm wondering if anyone is aware of a (non-hack) method to keep the executable produced by the rs.exe? Or any other way, short of writing my own application.

Thanks in advance.
This is an interesting feature request that I have not seen before. Unfortunately, there is currently no supported way to do this.

RS Scripts and Forms Authentication

Can you still run scripts such as CancelRunningJobs.rss after implementing
forms authentication?
I have forms authentication implemented and tried running this script
(CancelRunningJobs.rss) and I get the following error:
Could not connect to server:
http://xxx.xxx.xxx.xxx/reportserver/reportservice.asmx
the command I issued was:
rs -i CancelRunningJobs.rss -s http://myserver/reportserver
I am assuming this has to do with authentication (or lack of authentication).
Does anyone have examples of using scripts after implementing forms
authentication or know where I can look to find some?
Thanks in advance,
NickQuestion for you... How to get to Report Manager after implementing froms
authentication? Don't you need to authenticate first before trying to open
the Report Manager? If so, I would try authenticating first and then trying
to run the script. Just something to try.
"Nick P @. INDATA" wrote:
> Can you still run scripts such as CancelRunningJobs.rss after implementing
> forms authentication?
> I have forms authentication implemented and tried running this script
> (CancelRunningJobs.rss) and I get the following error:
> Could not connect to server:
> http://xxx.xxx.xxx.xxx/reportserver/reportservice.asmx
> the command I issued was:
> rs -i CancelRunningJobs.rss -s http://myserver/reportserver
> I am assuming this has to do with authentication (or lack of authentication).
> Does anyone have examples of using scripts after implementing forms
> authentication or know where I can look to find some?
> Thanks in advance,
> Nick
>