.NET Remoting and Reporting Services -- sql server reporting services

SMG
11/14/2005 1:30:13 AM

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!

[quoted text, click to view]

v-mingqc NO[at]SPAM online.microsoft.com
11/14/2005 6:11:50 AM

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.

Teo Lachev [MVP]
11/14/2005 8:31:16 AM

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/
----------------------------------------------
[quoted text, click to view]

SMG
11/16/2005 7:12:03 AM

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!

[quoted text, click to view]

Teo Lachev [MVP]
11/16/2005 6:57:05 PM

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/
----------------------------------------------
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : .NET Remoting and Reporting Services