Report protection

Is it possible to protect a report we create with the reporting services in
SQL Server 2005 so that end user will not be able to change and/or see the
definition of the report itself?
Mind you, the end user will have the admin privileges on their SQL server.
Thanks in advance.
GAZOn Jun 1, 3:45 am, "GAZ" <g...@.gaz.com> wrote:
> Is it possible to protect a report we create with the reporting services in
> SQL Server 2005 so that end user will not be able to change and/or see the
> definition of the report itself?
> Mind you, the end user will have the admin privileges on their SQL server.
> Thanks in advance.
> GAZ
The short answer is no. This link explains a possible option (though I
haven't attempted it myself).
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/acc9e38da9b9df58/254e225a2286f7c5?lnk=st&q=do+not+give+rdl+file+reporting+services&rnum=3#254e225a2286f7c5
Also, you could look into using report viewer controls in a custom
ASP.NET application to have control over the reports. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for the answer. I'll have a look into it and try to come up with
something.
GAZ
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1180741663.734238.160480@.u30g2000hsc.googlegroups.com...
> On Jun 1, 3:45 am, "GAZ" <g...@.gaz.com> wrote:
>> Is it possible to protect a report we create with the reporting services
>> in
>> SQL Server 2005 so that end user will not be able to change and/or see
>> the
>> definition of the report itself?
>> Mind you, the end user will have the admin privileges on their SQL
>> server.
>> Thanks in advance.
>> GAZ
>
> The short answer is no. This link explains a possible option (though I
> haven't attempted it myself).
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/acc9e38da9b9df58/254e225a2286f7c5?lnk=st&q=do+not+give+rdl+file+reporting+services&rnum=3#254e225a2286f7c5
> Also, you could look into using report viewer controls in a custom
> ASP.NET application to have control over the reports. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>