.NET Remoting and Reporting Services

We are trying to integrate .NET Remoting and Reporting Services through DSE.
The way we use to point out to Remoting server in the case of "normal"
applications (be it Windows Forms or ASP.NET) was through .config files where
under <configuration> section we create <system.runtime.remoting> subsection.
The problem we are facing at the moment is that we can not find appropriate
.config file where we could store this for Reporting Services. We've tried it
with RSReportDesigner.config, with (Visual Studio's) devenv.config, but
whatever we do, we get an error message "Type not found", when trying to
access the data from Report Designer.
Any hints?
Thanks in advance!Just a note: environment is Reporting Services 2000 SP2 + Visual Studio .NET
2003.|||Hi,
Welcome to use MSDN Managed Newsgroup!
Please store the information in the config file below and let me know
whether it works this time.
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\ReportingServicesService.exe.config
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Unfortunatelly, still the same :-(
I do not know, if it has anything to do with the fact that Visual Studio is
"hosting" environment, and not ReportingServices. Nevertheless, I've modified
devenv.exe.config as well, but this also didn't work...
My .config settings look like this:
<configuration>
.
.
.
<system.runtime.remoting>
<application>
<channels>
<channel ref="tcp" />
</channels>
<client>
<wellknown type="App.IPortal, App.Interfaces"
url="tcp://localhost:1234/Portal" />
</client>
</application>
</system.runtime.remoting>
</configuration>
Thanks for your time!
> Please store the information in the config file below and let me know
> whether it works this time.
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\ReportingServicesService.exe.config|||During runtime, when the report is rendered under the Report Server, you
should be able to read the settings from the Report Server web.config file.
C:\Program Files\Microsoft SQL
Server\MSSQL\ReportingServices\ReportServer\web.config
During design time, you should be able to hit F5 and use the Report Host
configuration file (RSReportHost.exe.config). The file doesn't exists so you
need to create it. In VS 2003, RSReportHost.exe should be located in
C:\Program Files\Microsoft Visual Studio 2003\Common7\IDE (I believe).
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"SMG" <dadoo@.online.nospam> wrote in message
news:F7BA992E-8325-4AB8-99D6-39BDF3956056@.microsoft.com...
> Unfortunatelly, still the same :-(
> I do not know, if it has anything to do with the fact that Visual Studio
> is
> "hosting" environment, and not ReportingServices. Nevertheless, I've
> modified
> devenv.exe.config as well, but this also didn't work...
> My .config settings look like this:
> <configuration>
> .
> .
> .
> <system.runtime.remoting>
> <application>
> <channels>
> <channel ref="tcp" />
> </channels>
> <client>
> <wellknown type="App.IPortal, App.Interfaces"
> url="tcp://localhost:1234/Portal" />
> </client>
> </application>
> </system.runtime.remoting>
> </configuration>
>
> Thanks for your time!
>
>> Please store the information in the config file below and let me know
>> whether it works this time.
>> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportServer\bin\ReportingServicesService.exe.config|||Thanks for the reply, but unfortunatelly this didn't work as well :-(
Anyway, I gave up, and created new remoting.config file which I deploy
together with the .dll file.
This seems to work now in Designer, but I am getting rsErrorExecutingCommand
when trying to execute it in ReportManager (in browser). Error message says:
Request for the permission of type
System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
Sure, I did some "googling", and most of the responses on this problem tell
me to make changes to proper *.config files that I did already :-(
Among the others in the rssrvpolicy.config file I have:
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Business.Reports.DPE"
Description="Code group for the Reports data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="c:\SQL Server\MSSQL\Reporting
Services\ReportServer\bin\Business.Reports.DPE.dll" />
</CodeGroup>
I am really stuck with this :-(
I guess it is needless to say that I highly appreciate *any* help!
Regards!
"Teo Lachev [MVP]" wrote:
> During runtime, when the report is rendered under the Report Server, you
> should be able to read the settings from the Report Server web.config file.
> C:\Program Files\Microsoft SQL
> Server\MSSQL\ReportingServices\ReportServer\web.config
> During design time, you should be able to hit F5 and use the Report Host
> configuration file (RSReportHost.exe.config). The file doesn't exists so you
> need to create it. In VS 2003, RSReportHost.exe should be located in
> C:\Program Files\Microsoft Visual Studio 2003\Common7\IDE (I believe).
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---|||Changing the config file often is not enought. You need to find from the
.NET documentation what permission remoting needs. Supposedly, or so I've
heard, .NET 2.0 includes an utility that would tell you what permission the
assembly needs. Once you have the permission, you need to assert in your
code before making the call. If nothing else works, you can bypass CAS
security altogether by changing the rssrvpolicy.config file as follows:
<PermissionSet
class="NamedPermissionSet"
version="1"
Name="Execution">
<IPermission
class="SecurityPermission"
version="1"
Flags="Full"
/>
or web.config by removing the trustLevel line from
<securityPolicy>
<trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
</securityPolicy>
As a side note, I wish the RS team could have simplified the RS 2005
security model to bring it in par with the SQL Server 2005 security model
where there are only three levels. I personally don't think that RS
developers need to become experts in CAS security.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"SMG" <dadoo@.online.nospam> wrote in message
news:061C5A60-A612-4357-993E-38429E7C63F4@.microsoft.com...
> Thanks for the reply, but unfortunatelly this didn't work as well :-(
> Anyway, I gave up, and created new remoting.config file which I deploy
> together with the .dll file.
> This seems to work now in Designer, but I am getting
> rsErrorExecutingCommand
> when trying to execute it in ReportManager (in browser). Error message
> says:
> Request for the permission of type
> System.Security.Permissions.SecurityPermission, mscorlib,
> Version=1.0.5000.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> Sure, I did some "googling", and most of the responses on this problem
> tell
> me to make changes to proper *.config files that I did already :-(
> Among the others in the rssrvpolicy.config file I have:
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Business.Reports.DPE"
> Description="Code group for the Reports data processing extension">
> <IMembershipCondition
> class="UrlMembershipCondition"
> version="1"
> Url="c:\SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\Business.Reports.DPE.dll" />
> </CodeGroup>
>
> I am really stuck with this :-(
> I guess it is needless to say that I highly appreciate *any* help!
>
> Regards!
>
> "Teo Lachev [MVP]" wrote:
>> During runtime, when the report is rendered under the Report Server, you
>> should be able to read the settings from the Report Server web.config
>> file.
>> C:\Program Files\Microsoft SQL
>> Server\MSSQL\ReportingServices\ReportServer\web.config
>> During design time, you should be able to hit F5 and use the Report Host
>> configuration file (RSReportHost.exe.config). The file doesn't exists so
>> you
>> need to create it. In VS 2003, RSReportHost.exe should be located in
>> C:\Program Files\Microsoft Visual Studio 2003\Common7\IDE (I believe).
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---