Custom data extension has trust issues

I wrote a custom data processing extension which works in preview mode,
but when viewing it from the report server I get the error:
--
An error has occurred during report processing. (rsProcessingAborted)
Cannot create command for data source 'MeridiumDataSource'.
(rsErrorCreatingCommand)
That assembly does not allow partially trusted callers.
--
I have put the correct codeblock tags in rssrvpolicy.config, right
after the codeblock with Url="$CodeGen$/*" as I'm supposed to:
--
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MeridiumCodeGroup"
Description="Code group for my data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportServer\bin\MeridiumDataEx
tension.dll"
/>
</CodeGroup>
--
I have some 3rd party assemblies that my DPE references; I also put a
codeblock for them in rssrvpolicy.config:
--
<CodeGroup
class="UnionCodeGroup"
version="3.2.0.148"
PermissionSetName="FullTrust"
Name="MeridiumCoreCodeGroup"
Description="This code group grants Meridium core code full
trust. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="[public key]"
/>
</CodeGroup>
--
I also put the followinig line in my AssemblyInfo.cs file:
--
[assembly: AllowPartiallyTrustedCallers]
--
None of these things changed the error. Any help would be greatly
appreciated.I guess I forgot to mention that this data extension is for reporting
services, and that this is sql server 2005.|||You might consider posting in the sqlserver.reportingsvcs newgroup.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
<hokietoner@.gmail.com> wrote in message
news:1150980095.588318.45210@.p79g2000cwp.googlegroups.com...
>I wrote a custom data processing extension which works in preview mode,
> but when viewing it from the report server I get the error:
> --
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create command for data source 'MeridiumDataSource'.
> (rsErrorCreatingCommand)
> That assembly does not allow partially trusted callers.
> --
> I have put the correct codeblock tags in rssrvpolicy.config, right
> after the codeblock with Url="$CodeGen$/*" as I'm supposed to:
> --
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="MeridiumCodeGroup"
> Description="Code group for my data processing extension">
> <IMembershipCondition
> class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\bin\MeridiumDataEx
tension.dll"
> />
> </CodeGroup>
> --
> I have some 3rd party assemblies that my DPE references; I also put a
> codeblock for them in rssrvpolicy.config:
> --
> <CodeGroup
> class="UnionCodeGroup"
> version="3.2.0.148"
> PermissionSetName="FullTrust"
> Name="MeridiumCoreCodeGroup"
> Description="This code group grants Meridium core code full
> trust. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="[public key]"
> />
> </CodeGroup>
> --
> I also put the followinig line in my AssemblyInfo.cs file:
> --
> [assembly: AllowPartiallyTrustedCallers]
> --
> None of these things changed the error. Any help would be greatly
> appreciated.
>

Custom data extension has trust issues

I wrote a custom data processing extension for reporting services in
SQL Server 2005. The extension works in preview mode, but when viewing
it from the report server I get the error:
--
An error has occurred during report processing. (rsProcessingAborted)
Cannot create command for data source 'MeridiumDataSource'.
(rsErrorCreatingCommand)
That assembly does not allow partially trusted callers.
--
I have put the correct codeblock tags in rssrvpolicy.config, right
after the codeblock with Url="$CodeGen$/*" as I'm supposed to:
--
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MeridiumCodeGroup"
Description="Code group for my data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportServer\bin\MeridiumDataExtension.dll"
/>
</CodeGroup>
--
I have some 3rd party assemblies that my DPE references; I also put a
codeblock for them in rssrvpolicy.config:
--
<CodeGroup
class="UnionCodeGroup"
version="3.2.0.148"
PermissionSetName="FullTrust"
Name="MeridiumCoreCodeGroup"
Description="This code group grants Meridium core code full
trust. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1"
PublicKeyBlob="[public key]"
/>
</CodeGroup>
--
I also put the followinig line in my AssemblyInfo.cs file:
--
[assembly: AllowPartiallyTrustedCallers]
--
None of these things changed the error. I also recently tried using
mscorcfg.msc to create a code group giving everything in the bin folder
(including all of my DLL's), and then I copied that codegroup to the RS
config file. This failed to change anything as well. Any help would be
greatly appreciated!Hi Ryan.
I have worked a lot with extensions and have had a lot of security issues.
I think the easiest way to find out which assembly needs permissions is to
debug. Step through you code and when a unthrusted method is called you will
get an exception.
Your third party assemblies might call something that need to be thrusted?
Kind regards
Martin Bring (Sogeti AB)
********************
"Ryan" wrote:
> I wrote a custom data processing extension for reporting services in
> SQL Server 2005. The extension works in preview mode, but when viewing
> it from the report server I get the error:
> --
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create command for data source 'MeridiumDataSource'.
> (rsErrorCreatingCommand)
> That assembly does not allow partially trusted callers.
> --
> I have put the correct codeblock tags in rssrvpolicy.config, right
> after the codeblock with Url="$CodeGen$/*" as I'm supposed to:
> --
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="MeridiumCodeGroup"
> Description="Code group for my data processing extension">
> <IMembershipCondition
> class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\ReportServer\bin\MeridiumDataExtension.dll"
> />
> </CodeGroup>
> --
> I have some 3rd party assemblies that my DPE references; I also put a
> codeblock for them in rssrvpolicy.config:
> --
> <CodeGroup
> class="UnionCodeGroup"
> version="3.2.0.148"
> PermissionSetName="FullTrust"
> Name="MeridiumCoreCodeGroup"
> Description="This code group grants Meridium core code full
> trust. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="[public key]"
> />
> </CodeGroup>
> --
> I also put the followinig line in my AssemblyInfo.cs file:
> --
> [assembly: AllowPartiallyTrustedCallers]
> --
> None of these things changed the error. I also recently tried using
> mscorcfg.msc to create a code group giving everything in the bin folder
> (including all of my DLL's), and then I copied that codegroup to the RS
> config file. This failed to change anything as well. Any help would be
> greatly appreciated!
>

custom code and messagebox popup

Hi at all,
I have custom code written the to show a message Box.
It was working fine in DotNet2005 Development enviroment preview tab.
But it is't working when i deploy this report to the web.
Please use a reference to
System.Windows.Forms, Version=2.0.0.0
Public Function Test() As String
System.Windows.Forms.MessageBox.Show("Hello")
' Or
Msgbox "Hello2"
Return "OK"
End Function
Can anyone help me
martinYou can't use System.Windows.Forms for a web page. Please see the following
URL: http://www.freevbcode.com/ShowCode.asp?ID=5918. If you don't want to
go there, use the following function to stream out a message box
Public Sub ASPNET_MsgBox(ByVal Message As String)
System.Web.HttpContext.Current.Response.Write("<SCRIPT
LANGUAGE=""JavaScript"">" & vbCrLf)
System.Web.HttpContext.Current.Response.Write("alert(""" & Message &
""")" & vbCrLf)
System.Web.HttpContext.Current.Response.Write("</SCRIPT>")
End Sub
--
================Living proof that 95% of programmers are idiots.
"Martin Jau" wrote:
> Hi at all,
> I have custom code written the to show a message Box.
> It was working fine in DotNet2005 Development enviroment preview tab.
> But it is't working when i deploy this report to the web.
> Please use a reference to
> System.Windows.Forms, Version=2.0.0.0
> Public Function Test() As String
> System.Windows.Forms.MessageBox.Show("Hello")
> ' Or
> Msgbox "Hello2"
> Return "OK"
> End Function
> Can anyone help me
> martin
>
>

Custom assembly, not a trusted assembly

When I add a reference to my custom assembly to the report and try to preview it I get the following error message:
Parameters Error

The report references the code module ‘Employee, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null’, which is not a trusted assembly.

OK
I have modifed the reporting services rspreviewpolicy.config and rssrvpolicy.config with the following:

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Custom_Code_Group"
Description="This code group grants custom code full trust. ">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies\Employee.dll"
/>
</CodeGroup>
However it has made no difference. I know I must be missing something. Can anyone point me in the right direction.

Thank you in advance.I just upgraded from RS 2005 Beta 1 to Beta 2. Now I'm having the same problem. I had all of my custom assemblies working fine in Beta 1. When I installed Beta 2, I gleaned from a few postings that I had to move my assemblies to

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

Done.

I then modified RSPreviewPolicy.config in the same folder to give access to these assemblies.

<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="SystemCommon"
Description="Grants permissions to the User Utilities assembly">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\et.User.SystemCommon.dll"
/>
</CodeGroup>

Doesn't work.

"The report references the code module 'et.User.SystemCommon' .... , which is not a trusted assembly."

Question : are there any significant changes to Code Access Security from Beta 1 to Beta 2? In Beta 1, if you did anything wrong in the config file (ie "URLMembershipCondition" vs. "UrlMembershipCondition"), the whole IDE gave out. I'm wondering if perhaps this is a more subtle way of telling me the same thing?

Significantly, the reports are working fine on the server.

I'ma go getta coffee.|||There was a problem with custom assemblies in some of the earlier builds. Your solution should work for the released version.

Custom assembly problems in RS

Hi,
I have a custom assembly that is working just fine in the Preview tab in Report Designer. However, the popup preview is blowing up with the error: Execute permissions cannot be acquired.
I've added a code group (at the top of the code group section) in the rsPreviewPolicy.config, which is residing in the default location. My .dll is in the correct place and functioning, as evidenced by the preview tab success. The .dll is using ADO.net to call a stored proc in an Oracle database.
I added the code group by directly editing the config file; I'm no XML veteran, so I'm not sure if it's configured correctly. The .Net editor tells me it's "well-formed". When it wasn't well-formed, I got an error regarding loading the file, so I'm assuming this isn't the problem.
Any insight would be appreciated.
Doug
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Did you sign the file using the sn command line tool that comes with VS?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23W6pS%23eaEHA.2840@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a custom assembly that is working just fine in the Preview tab in
> Report Designer. However, the popup preview is blowing up with the error:
> Execute permissions cannot be acquired.
> I've added a code group (at the top of the code group section) in the
> rsPreviewPolicy.config, which is residing in the default location. My
> .dll is in the correct place and functioning, as evidenced by the preview
> tab success. The .dll is using ADO.net to call a stored proc in an Oracle
> database.
> I added the code group by directly editing the config file; I'm no XML
> veteran, so I'm not sure if it's configured correctly. The .Net editor
> tells me it's "well-formed". When it wasn't well-formed, I got an error
> regarding loading the file, so I'm assuming this isn't the problem.
> Any insight would be appreciated.
> Doug
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.|||It sounds like you did not assert permissions to open a database connection.
Unless you assert the permission explicitly in the custom assembly code, it
will fail with a security exception.
Example for opening a connection to a SQL Server:
...
SqlClientPermission permission = new
SqlClientPermission(PermissionState.Unrestricted);
try
{
permission.Assert(); // Assert security permission!
SqlConnection con = new SqlConnection("...");
con.Open();
...
}
You might also want to check out these links:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_0so6.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconAssert.asp
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_prog_rdl_8wyq.asp
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23W6pS%23eaEHA.2840@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a custom assembly that is working just fine in the Preview tab in
Report Designer. However, the popup preview is blowing up with the error:
Execute permissions cannot be acquired.
> I've added a code group (at the top of the code group section) in the
rsPreviewPolicy.config, which is residing in the default location. My .dll
is in the correct place and functioning, as evidenced by the preview tab
success. The .dll is using ADO.net to call a stored proc in an Oracle
database.
> I added the code group by directly editing the config file; I'm no XML
veteran, so I'm not sure if it's configured correctly. The .Net editor
tells me it's "well-formed". When it wasn't well-formed, I got an error
regarding loading the file, so I'm assuming this isn't the problem.
> Any insight would be appreciated.
> Doug
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

custom assemblies problem

I have built a custom assembly, I copied it to the right folders and wrote
some code to call the component.
It works fine in preview mode, but when I deploy the report to another
server I get the error:
"error while loading code module 'x', version='x' ..."
I feel I tried everything, copying the dll myself to the server's
reportserver\bin folder, giving read & execute permissions, creating the xml
nodes in the RSReportServer.config on the server etc.
Always that error.
Is there some description on what to do if you deploy your reports with
custom assemblies to another server?This is a multi-part message in MIME format.
--=_NextPart_000_005C_01C5078D.1745CA00
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
might be a code access security problem
to diagnose (do not do this on a production server) please find =rssrvpolicy.config file in ReportServer folder and modify the following:
old:
<CodeGroup class=3D"FirstMatchCodeGroup"
version=3D"1"
PermissionSetName=3D"Nothing">
new:
<CodeGroup class=3D"FirstMatchCodeGroup"
version=3D"1"
PermissionSetName=3D"FullTrust">
Restart iis and see if it runs the report, let me know the results. If =it runs - it's a security problem, I will let you know further steps.
! Please undo the change of rssrvpolicy.config afterwards...!
-- Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml; =SQE.
This posting is provided "AS IS" with no warranties, and confers no =rights
"Serv=E9 La" <blabla@.bestaatniet.nl> wrote in message =news:OP9Oyq6BFHA.1004@.TK2MSFTNGP15.phx.gbl...
> I have built a custom assembly, I copied it to the right folders and =wrote
> some code to call the component.
> It works fine in preview mode, but when I deploy the report to another
> server I get the error:
> "error while loading code module 'x', version=3D'x' ..."
> > I feel I tried everything, copying the dll myself to the server's
> reportserver\bin folder, giving read & execute permissions, creating =the xml
> nodes in the RSReportServer.config on the server etc.
> > Always that error.
> > Is there some description on what to do if you deploy your reports =with
> custom assemblies to another server?
> >
--=_NextPart_000_005C_01C5078D.1745CA00
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

might be a code access security problem
to diagnose (do not do this on a production server) =please find rssrvpolicy.config file in ReportServer folder and modify the following:
old:
&nbs=p; new:
&nbs=p;
Restart iis and see if it runs the report, let me =know the results. If it runs - it's a security problem, I will let you know =further steps.
! Please undo the change of rssrvpolicy.config afterwards...!
-- Alex MineevSoftware Design Engineer. =Report expressions; Code Access Security; Xml; SQE.
This posting is provided "AS IS" with no warranties, =and confers no rights
"Serv=E9 La" wrote in =message news:OP9Oyq6BFHA.1004@.TK2MSFTNGP15.phx.gbl...> I have built a custom =assembly, I copied it to the right folders and wrote> some code to call the component.> It works fine in preview mode, but when I deploy the =report to another> server I get the error:> "error while loading =code module 'x', version=3D'x' ..."> > I feel I tried =everything, copying the dll myself to the server's> reportserver\bin folder, giving =read & execute permissions, creating the xml> nodes in the RSReportServer.config on the server etc.> > Always that error.> > Is there some description on what to do if you =deploy your reports with> custom assemblies to another server?> =>

---

--=_NextPart_000_005C_01C5078D.1745CA00--|||This is a multi-part message in MIME format.
--=_NextPart_000_0013_01C50905.46797AA0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Thank you for answering. The problem was solved, it was a stupid mistake =of mine.
The good news is that the FullTrust setting did help me later when I =needed to load assemblies from report code :)
"Alexandre Mineev [MSFT]" <almineev@.microsoft.com> schreef in bericht =news:eAOfmA9BFHA.1260@.TK2MSFTNGP12.phx.gbl...
might be a code access security problem
to diagnose (do not do this on a production server) please find =rssrvpolicy.config file in ReportServer folder and modify the following:
old:
<CodeGroup class=3D"FirstMatchCodeGroup"
version=3D"1"
PermissionSetName=3D"Nothing">
new:
<CodeGroup class=3D"FirstMatchCodeGroup"
version=3D"1"
PermissionSetName=3D"FullTrust">
Restart iis and see if it runs the report, let me know the results. If =it runs - it's a security problem, I will let you know further steps.
! Please undo the change of rssrvpolicy.config afterwards...!
-- Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; =Xml; SQE.
This posting is provided "AS IS" with no warranties, and confers no =rights
"Serv=E9 La" <blabla@.bestaatniet.nl> wrote in message =news:OP9Oyq6BFHA.1004@.TK2MSFTNGP15.phx.gbl...
> I have built a custom assembly, I copied it to the right folders and =wrote
> some code to call the component.
> It works fine in preview mode, but when I deploy the report to =another
> server I get the error:
> "error while loading code module 'x', version=3D'x' ..."
> > I feel I tried everything, copying the dll myself to the server's
> reportserver\bin folder, giving read & execute permissions, creating =the xml
> nodes in the RSReportServer.config on the server etc.
> > Always that error.
> > Is there some description on what to do if you deploy your reports =with
> custom assemblies to another server?
> >
--=_NextPart_000_0013_01C50905.46797AA0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Thank you for answering. The problem =was solved, it was a stupid mistake of mine.
The good news is that the FullTrust =setting did help me later when I needed to load assemblies from report code :)
"Alexandre Mineev [MSFT]" =schreef in bericht news:eAOfmA9BFHA.1260=@.TK2MSFTNGP12.phx.gbl...
might be a code access security =problem
to diagnose (do not do this on a production =server) please find rssrvpolicy.config file in ReportServer folder and modify the following:
old:
&nbs=p; new:
&nbs=p;
Restart iis and see if it runs the report, let me =know the results. If it runs - it's a security problem, I will let you know =further steps.

! Please undo the change of =rssrvpolicy.config afterwards...!
-- Alex MineevSoftware Design =Engineer. Report expressions; Code Access Security; Xml; SQE.

This posting is provided "AS IS" with no =warranties, and confers no rights
"Serv=E9 La" wrote in =message news:OP9Oyq6BFHA.1004@.TK2MSFTNGP15.phx.gbl...> I have built a custom =assembly, I copied it to the right folders and wrote> some code to call the = component.> It works fine in preview mode, but when I deploy =the report to another> server I get the error:> "error while =loading code module 'x', version=3D'x' ..."> > I feel I tried =everything, copying the dll myself to the server's> reportserver\bin =folder, giving read & execute permissions, creating the xml> nodes in the RSReportServer.config on the server etc.> > Always that error.> > Is there some description on what to do if you =deploy your reports with> custom assemblies to another server?> = >

---

--=_NextPart_000_0013_01C50905.46797AA0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C50916.FB775740
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Please do not use FullTrust in production environment. It ultimately =opens RS for attacks.
The use of FullTrust was needed for diagnostics only.
This article describe what needs to be done for custom assemblies if =they do not work by default: =http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSPROG=
/htm/rsp_prog_rdl_8mue.asp
-- Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml; =SQE.
This posting is provided "AS IS" with no warranties, and confers no =rights
"Serv=E9 La" <blabla@.bestaatniet.nl> wrote in message =news:uSURmzPCFHA.3492@.TK2MSFTNGP12.phx.gbl...
Thank you for answering. The problem was solved, it was a stupid =mistake of mine.
The good news is that the FullTrust setting did help me later when I =needed to load assemblies from report code :)
"Alexandre Mineev [MSFT]" <almineev@.microsoft.com> schreef in =bericht news:eAOfmA9BFHA.1260@.TK2MSFTNGP12.phx.gbl...
might be a code access security problem
to diagnose (do not do this on a production server) please find =rssrvpolicy.config file in ReportServer folder and modify the following:
old:
<CodeGroup class=3D"FirstMatchCodeGroup"
version=3D"1"
PermissionSetName=3D"Nothing">
new:
<CodeGroup class=3D"FirstMatchCodeGroup"
version=3D"1"
PermissionSetName=3D"FullTrust">
Restart iis and see if it runs the report, let me know the results. =If it runs - it's a security problem, I will let you know further steps.
! Please undo the change of rssrvpolicy.config afterwards...!
-- Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; =Xml; SQE.
This posting is provided "AS IS" with no warranties, and confers no =rights
"Serv=E9 La" <blabla@.bestaatniet.nl> wrote in message =news:OP9Oyq6BFHA.1004@.TK2MSFTNGP15.phx.gbl...
> I have built a custom assembly, I copied it to the right folders =and wrote
> some code to call the component.
> It works fine in preview mode, but when I deploy the report to =another
> server I get the error:
> "error while loading code module 'x', version=3D'x' ..."
> > I feel I tried everything, copying the dll myself to the server's
> reportserver\bin folder, giving read & execute permissions, =creating the xml
> nodes in the RSReportServer.config on the server etc.
> > Always that error.
> > Is there some description on what to do if you deploy your reports =with
> custom assemblies to another server?
> >
--=_NextPart_000_000F_01C50916.FB775740
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Please do not use FullTrust in production =environment. It ultimately opens RS for attacks.
The use of FullTrust was needed for diagnostics only.
This article describe what needs to be done for =custom assemblies if they do not work by default: http://msdn.microsoft.com/library/def=ault.asp?url=3D/library/en-us/RSPROG/htm/rsp_prog_rdl_8mue.asp=-- Alex MineevSoftware Design =Engineer. Report expressions; Code Access Security; Xml; SQE.
This posting is provided "AS IS" with no warranties, and confers no =rights
"Serv=E9 La" =wrote in message news:uSURmzPCFHA.3492=@.TK2MSFTNGP12.phx.gbl...
Thank you for answering. The problem =was solved, it was a stupid mistake of mine.
The good news is that the FullTrust =setting did help me later when I needed to load assemblies from report code :)


"Alexandre Mineev [MSFT]" =schreef in bericht news:eAOfmA9BFHA.1260=@.TK2MSFTNGP12.phx.gbl...
might be a code access security =problem
to diagnose (do not do this on a production =server) please find rssrvpolicy.config file in ReportServer folder and modify the following:
old:
&nbs=p; new:
&nbs=p;
Restart iis and see if it runs the report, let =me know the results. If it runs - it's a security problem, I will let you know =further steps.

! Please undo the change of =rssrvpolicy.config afterwards...!
-- Alex MineevSoftware Design =Engineer. Report expressions; Code Access Security; Xml; SQE.

This posting is provided "AS IS" with no =warranties, and confers no rights
"Serv=E9 La" wrote =in message news:OP9Oyq6BFHA.1004@.TK2MSFTNGP15.phx.gbl...> I have built a custom =assembly, I copied it to the right folders and wrote> some code to call =the component.> It works fine in preview mode, but when I deploy =the report to another> server I get the error:> "error =while loading code module 'x', version=3D'x' ..."> > I feel =I tried everything, copying the dll myself to the server's> =reportserver\bin folder, giving read & execute permissions, creating the =xml> nodes in the RSReportServer.config on the server etc.> => Always that error.> > Is there some description on =what to do if you deploy your reports with> custom assemblies to another = server?> > =

---

--=_NextPart_000_000F_01C50916.FB775740--

Custom Assemblies

Hi,
I had an external assembly for which i had added the reference in the
report.When i view the report in PREVIEW section the report is displyed
properly with the data but when i review in browser the report is shown with
error as "Security Error" where i am referencing the external DLL. Can
anybody tell me how to set security for the external DLL.
Thanks
JasvinderLook at this thread, you have to get Reporting Services trust your DLL.
http://groups.google.de/groups?hl=de&lr=&threadm=OAxg3EQRFHA.4028%40tk2msftngp13.phx.gbl&rnum=1&prev=/groups%3Fq%3Dreporting%2Bservices%2Bassembly%2Bgac%26hl%3Dde%26lr%3D%26scoring%3Dd%26selm%3DOAxg3EQRFHA.4028%2540tk2msftngp13.phx.gbl%26rnum%3D1
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Jasvinder" <Jasvinder@.discussions.microsoft.com> schrieb im Newsbeitrag
news:7800CAD7-7871-4104-B175-9FC2133CAC9A@.microsoft.com...
> Hi,
> I had an external assembly for which i had added the reference in the
> report.When i view the report in PREVIEW section the report is displyed
> properly with the data but when i review in browser the report is shown
> with
> error as "Security Error" where i am referencing the external DLL. Can
> anybody tell me how to set security for the external DLL.
> Thanks
> Jasvinder