Custom Assemblies & ADO.NET

Hi everyone,
I have a problem with custom assemblies. I have a report which uses a custom
assembly. This custom assembly access a SQL Server database using ADO.NET.
The report runs ok in the Report Designer, but I get a error (#Error) in the
Report Manager.
I don't know if I have to makeany changes in the Report Server configuration
files in order to allow database access. And I don'tknow ig I have to add any
code to my class.
I think that there is a security problem, but I haven't found any help in
the BOL.
Thanks in advance.
Javi.Javier,
The reason for this is the Code Access Security policies that the Report
Server applies to custom code. You need to elevate the default permission
granted your custom assembly.
Please read the following thread:
http://groups.google.com/groups?hl=en&lr=&threadm=%23Rlrsz%24cEHA.1604%40TK2MSFTNGP11.phx.gbl&rnum=2&prev=/groups%3Fq%3Dsqlconnection%2Bcas%2Bgroup:*.reportingsvcs%26hl%3Den%26lr%3D%26selm%3D%2523Rlrsz%2524cEHA.1604%2540TK2MSFTNGP11.phx.gbl%26rnum%3D2
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Javier Catala" <JavierCatala@.discussions.microsoft.com> wrote in message
news:72D4CC25-1830-4A50-BB7A-3DE401746C1E@.microsoft.com...
> Hi everyone,
> I have a problem with custom assemblies. I have a report which uses a
custom
> assembly. This custom assembly access a SQL Server database using ADO.NET.
> The report runs ok in the Report Designer, but I get a error (#Error) in
the
> Report Manager.
> I don't know if I have to makeany changes in the Report Server
configuration
> files in order to allow database access. And I don'tknow ig I have to add
any
> code to my class.
> I think that there is a security problem, but I haven't found any help in
> the BOL.
> Thanks in advance.
> Javi.