Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.
|||bump.... I'm not even getting a dialog...

|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.
|||bump.... I'm not even getting a dialog...

|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying with custom Forms Security enabled

I have recently enabled a custom Forms Security on my Windows 2003 Server w/ SQL Server 2005 Reporting Services. All the functionality I would expect is working properly, except for the ability to deploy to the reports server from inside my Visual Studio 2005 Reports Project.

The 'Reporting Services Login' window opens, prompting me for a username and password. Regardless of what is supplied, the window keeps reappearing, and I am unable to deploy. I am able to upload the files from within the Report Manager, but that is time consuming and inelegant.

Any help would be greatly appreciated!

Anyone? This is pretty peculiar, and it looks like there was a similar issue with SQL Server 2000 and its reporting services. Has any experienced anything like this?|||

I too am stuck:

I have setup Forms Authentication on RS2005 and the report manager is working
swell it redirects to a log in page, authenticates against our data
source/ldap server and returns to the report manager with the appropriate
roles/authorizations.
However, I don't know how to deploy the reports/models to the report server. I no longer have a prompt in Visual Studio after we enabled the
forms authenticaiton; keeping in mind with forms authentication you aren't
using windows authorization/active directory. How do I continue to deploy
reports or report models to the report server/manager with forms
authentication. Specific configuration steps would be helpful. Currently we
get an error something to the effect that user '' doesn't have permissions to
the destination. So basically without a prompt window it doesn't seem to know
who I am anymore. How would I login or use/create a cookie to tell it who I
am if I don't have a login prompt inside the Visual Studio 2005?
Thanks!

|||no idea. it doesnt make sense that the prompt in visual studio would disapper, however, since the reports could be deployed to any server...|||I had the same problem: I was prompted for username/password in my Report Model and Report Server projects. Deploying the Report Server project worked fine, but the Report Model project sent an empty username string to the logon function.

I finally figured out that the two project types handle the username string differently. For getting the Report Model to deploy correctly, you must specify an authority before the username even if you don't use one in your custom security extension. (i.e. ANYTHING\username or .\username, \username doesn't work). Done so, the username string gets parsed correctly and the deployment works fine.|||bump.... I'm not even getting a dialog...|||

Not sure if anyone out there is still struggling with the continual login dialog or not. I was and found out what my problem was. I was trying to deploy to "http:\localhost\reports" instead of http:\localhost\ReportServer"!

ugh!

Anyway, hope this helps someone!

Deploying Custom Task to Production Server

This seems like a rather simple questions that I've hesitated posting for a day now, but as of yet I can't really find an answer through my searches online.

My SSIS package is using a couple of the Konesans Transforms, this worked fine on my development box with my dev SQL server. The time has come now to deploy my package to my production SQL server. The instructions on installing the transforms on my dev box all uses Visual Studio to add the components.

Is there a way to deploy 3rd party (own my own) SSIS tasks with the package? Does it require a seperate install? How can I do it without Visual Studio?

Thanks for any help,

-Dan

You don't need Visual Studio to install the custom components. You need to add them to the toolbox in BIDS in order to use them, but that's not teh same as installing them.

All you need to do on your production server is make sure that the DLLs are in the GAC (c:\windows\assembly)

-Jamie

|||

Thanks Jamie. I can do that.

I'm hoping though the future might hold a little more functionality in the "Deployment Utility." I'm also using my own libraries for some script tasks and it'd be nice if the deployment utility recognized the dependancy in visual studio and provides a way for it to be installed into the GAC on deployment.

|||

Nice idea. Request it at the Feedback Centre: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

|||

Thanks for the link, it was handy for submitting a bug on my FTP issue.

|||I downloaded Visual Basic studio 2005 Trying to do a project for my class final and it has no toolbox? Please help|||

>I downloaded Visual Basic studio 2005 Trying to do a project for my class final and it has no toolbox? Please help

Sorry, we'll not be able to answe this here. Please repost this in the appropriate Visual Studio forum where I'm sure they will jump on it.

Deploying custom assemblies

Hi All,
I have developed a custom assembly and now I want to deploy it on to
the server as per the instructions mentioned in the books online
(ms-help://MS.RSBOL80.1033/RSPROG/htm/rsp_prog_rdl_8mue.htm), I want
to remove the commented portion of the RSReportServer.config file to
enable custom assemblies permission.However, I find that I dont have
any such commented portion in the file. I am using the Developer
edition of Reporting Services.
Can any one guide me if the file being edited is correct ? Does it
have to do something with the edition of RS that I am using?
Thanks in advance,
Lone CrusaderHi Loner,
Depending on what permission levels your custom assemblies need you'll need
to update your RS policy file and deply that too.
You'll need to add a PermissionSet AND CodeGroup configuration settings
(when using Report Designer, it uses it's own levels of Code Trusting (it
fakes a few things), when you do it by yourself, you'll need to define this
Code Trust (RS "trusting" your custom assembly) yourself
- peteZ
"Lone Crusader" <ravi32ful@.rediffmail.com> wrote in message
news:cc093b66.0409110001.3a1ac8bd@.posting.google.com...
> Hi All,
> I have developed a custom assembly and now I want to deploy it on to
> the server as per the instructions mentioned in the books online
> (ms-help://MS.RSBOL80.1033/RSPROG/htm/rsp_prog_rdl_8mue.htm), I want
> to remove the commented portion of the RSReportServer.config file to
> enable custom assemblies permission.However, I find that I dont have
> any such commented portion in the file. I am using the Developer
> edition of Reporting Services.
> Can any one guide me if the file being edited is correct ? Does it
> have to do something with the edition of RS that I am using?
> Thanks in advance,
> Lone Crusader|||Bryant Likes wrote a nice article on this issue - read it at
http://blogs.sqlxml.org/bryantlikes/articles/824.aspx.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Lone Crusader" <ravi32ful@.rediffmail.com> wrote in message
news:cc093b66.0409110001.3a1ac8bd@.posting.google.com...
> Hi All,
> I have developed a custom assembly and now I want to deploy it on to
> the server as per the instructions mentioned in the books online
> (ms-help://MS.RSBOL80.1033/RSPROG/htm/rsp_prog_rdl_8mue.htm), I want
> to remove the commented portion of the RSReportServer.config file to
> enable custom assemblies permission.However, I find that I dont have
> any such commented portion in the file. I am using the Developer
> edition of Reporting Services.
> Can any one guide me if the file being edited is correct ? Does it
> have to do something with the edition of RS that I am using?
> Thanks in advance,
> Lone Crusader

Deployed report with custom assembly fail when calling web service

Hi,
I'm developing a report that calls a web service using a custom assembly.
I've got the code working in VS.NET, but when I deploy to my local Report
Server, I get this:
System.Security.SecurityException: Request for the permission of type
System.Security.Permissions.SecurityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed
I have added the following to RSReportServer.config:
<CustomAssemblies>
<Assembly Name="cmcs.wsclient.dll, Version=1.0.xxx.xxxx,
Culture=neutral, PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1"
Unrestricted="true"
/>
<IPermission
class="System.Security.Permissions.EnvironmentPermission"
version="1"
Unrestricted="true"
/>
</PermissionSet>
</Assembly>
<Assembly Name="cmcs.msrs.webserviceclient, Version=1.0.xxx.xxxx,
Culture=neutral, PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1"
Unrestricted="true"
/>
<IPermission
class="System.Security.Permissions.EnvironmentPermission"
version="1"
Unrestricted="true"
/>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execute"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
In rssrvpolicy.config, I have changed the PermissionSet for
Report_Expressions_Default_Permissions to FullTrust and added the following:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="ReportServer-cmcs.msrs.webserviceclient"
Description="Codegroup generated by the .NET
Configuration tool">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program
Files/Microsoft SQL Server/MSSQL/Reporting
Services/ReportServer/bin/cmcs.msrs.webserviceclient.dll"/>
</CodeGroup>
It works to call a HelloWorld method returning a string from the custom
assembly, so there is no total failure, but calling the method to invoke the
web service fails.
Please help, I feel that I'm totally stuck!
JonasBy moving my CodeGroup in rssrvpolicy.config to right under the first
default CodeGroup, it I got it to work ...
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="Nothing">
<IMembershipCondition
class="AllMembershipCondition"
version="1"
/>
***** RIGHT UNDER HERE *****
It seems like my CodeGroup wasn't used by ReportServer until the move. We'll
just have to see how long time it will work before it breaks again ;-)
Jonas" <Jonas@.nospam.pl> wrote in message
news:u$YVj30IGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm developing a report that calls a web service using a custom assembly.
> I've got the code working in VS.NET, but when I deploy to my local Report
> Server, I get this:
> System.Security.SecurityException: Request for the permission of type
> System.Security.Permissions.SecurityPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed
> I have added the following to RSReportServer.config:
> <CustomAssemblies>
> <Assembly Name="cmcs.wsclient.dll, Version=1.0.xxx.xxxx,
> Culture=neutral, PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1"
> Unrestricted="true"
> />
> <IPermission
> class="System.Security.Permissions.EnvironmentPermission"
> version="1"
> Unrestricted="true"
> />
> </PermissionSet>
> </Assembly>
> <Assembly Name="cmcs.msrs.webserviceclient, Version=1.0.xxx.xxxx,
> Culture=neutral, PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1"
> Unrestricted="true"
> />
> <IPermission
> class="System.Security.Permissions.EnvironmentPermission"
> version="1"
> Unrestricted="true"
> />
> </PermissionSet>
> </Assembly>
> <Default>
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execute"
> />
> </PermissionSet>
> </Default>
> </CustomAssemblies>
> In rssrvpolicy.config, I have changed the PermissionSet for
> Report_Expressions_Default_Permissions to FullTrust and added the
following:
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Attributes="LevelFinal"
>
Name="ReportServer-cmcs.msrs.webserviceclient"
> Description="Codegroup generated by the .NET
> Configuration tool">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program
> Files/Microsoft SQL Server/MSSQL/Reporting
> Services/ReportServer/bin/cmcs.msrs.webserviceclient.dll"/>
> </CodeGroup>
> It works to call a HelloWorld method returning a string from the custom
> assembly, so there is no total failure, but calling the method to invoke
the
> web service fails.
> Please help, I feel that I'm totally stuck!
> Jonas
>

Deployed custom assembly doesn't call web service

Hi,
I've got a custom assembly used in Rptsvcs that calls a web service on the
local host. When run in Report Designer, it works as planned, but when run
in Report Server, it doesn't call the web service. I have a
HelloWorld-method in the custom assembly that works, so the assembly is
working but it can't call the web service.
I have modified RSReportServer.config as follows:
<CustomAssemblies>
<Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1">
<ConnectAccess>
<URI uri="$OriginHost$"/>
</ConnectAccess>
</IPermission>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
And the policy file rssrvpolicy.config is also modified:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="cmcs.wsclient"
Description="Codegroup generated by the .NET Configuration tool">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program Files/Microsoft SQL
Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
</CodeGroup>
Any tips?
JonasI forgot to mention that I make an assert in code before the call to the web
service:
WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
webPerm.Assert();
TIA
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've got a custom assembly used in Rptsvcs that calls a web service on the
> local host. When run in Report Designer, it works as planned, but when run
> in Report Server, it doesn't call the web service. I have a
> HelloWorld-method in the custom assembly that works, so the assembly is
> working but it can't call the web service.
> I have modified RSReportServer.config as follows:
> <CustomAssemblies>
> <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1">
> <ConnectAccess>
> <URI uri="$OriginHost$"/>
> </ConnectAccess>
> </IPermission>
> </PermissionSet>
> </Assembly>
> <Default>
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution"
> />
> </PermissionSet>
> </Default>
> </CustomAssemblies>
>
> And the policy file rssrvpolicy.config is also modified:
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Attributes="LevelFinal"
> Name="cmcs.wsclient"
> Description="Codegroup generated by the .NET Configuration tool">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program Files/Microsoft SQL
> Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> </CodeGroup>
> Any tips?
> Jonas
>
>|||After some more investigation, I found out that it is the following
statement
ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
I need this to get the web services to use the callers identity. The
exception thrown is:
Request for the permission of type
System.Security.Permissions.EnvironmentPermission
As before, it works in Report Designer so the code is alright, it is the
security configuration that fails somewhere.
/Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> I forgot to mention that I make an assert in code before the call to the
web
> service:
> WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> webPerm.Assert();
> TIA
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I've got a custom assembly used in Rptsvcs that calls a web service on
the
> > local host. When run in Report Designer, it works as planned, but when
run
> > in Report Server, it doesn't call the web service. I have a
> > HelloWorld-method in the custom assembly that works, so the assembly is
> > working but it can't call the web service.
> >
> > I have modified RSReportServer.config as follows:
> >
> > <CustomAssemblies>
> > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> > PublicKeyToken=xxx">
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution, Assertion"
> > />
> > <IPermission class="System.Security.Permissions.WebPermission"
> > version="1">
> > <ConnectAccess>
> > <URI uri="$OriginHost$"/>
> > </ConnectAccess>
> > </IPermission>
> > </PermissionSet>
> > </Assembly>
> >
> > <Default>
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution"
> > />
> > </PermissionSet>
> > </Default>
> > </CustomAssemblies>
> >
> >
> > And the policy file rssrvpolicy.config is also modified:
> >
> > <CodeGroup class="UnionCodeGroup"
> > version="1"
> > PermissionSetName="FullTrust"
> > Attributes="LevelFinal"
> > Name="cmcs.wsclient"
> > Description="Codegroup generated by the .NET Configuration
tool">
> > <IMembershipCondition class="UrlMembershipCondition"
> > version="1"
> > Url="file://C:/Program Files/Microsoft SQL
> > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > </CodeGroup>
> >
> > Any tips?
> >
> > Jonas
> >
> >
> >
>|||I've finally gotten the report to run in Report Server, but it took a while
and a nasty config to do it. It seems that the only way to get this to work
is to change the PermissionSet for Report_Expressions_Default_Permissions in
rssrvpolicy.config to FullTrust. I've tried to create a custom PermissionSet
with CASPOL where I ended up adding all permissions and setting them to
Unrestricted="true" thinking that I could then remove one at a time to
finally get a lower priviliege permission set, but the only thing that works
is FullTrust.
Is there someone else that have experienced the same thing?
Brgds
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
> After some more investigation, I found out that it is the following
> statement
> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
> I need this to get the web services to use the callers identity. The
> exception thrown is:
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission
> As before, it works in Report Designer so the code is alright, it is the
> security configuration that fails somewhere.
> /Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> > I forgot to mention that I make an assert in code before the call to the
> web
> > service:
> >
> > WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> > webPerm.Assert();
> > TIA
> >
> > Jonas
> >
> > "Jonas" <Jonas@.nospam.pl> wrote in message
> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I've got a custom assembly used in Rptsvcs that calls a web service on
> the
> > > local host. When run in Report Designer, it works as planned, but when
> run
> > > in Report Server, it doesn't call the web service. I have a
> > > HelloWorld-method in the custom assembly that works, so the assembly
is
> > > working but it can't call the web service.
> > >
> > > I have modified RSReportServer.config as follows:
> > >
> > > <CustomAssemblies>
> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
Culture=neutral,
> > > PublicKeyToken=xxx">
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution, Assertion"
> > > />
> > > <IPermission
class="System.Security.Permissions.WebPermission"
> > > version="1">
> > > <ConnectAccess>
> > > <URI uri="$OriginHost$"/>
> > > </ConnectAccess>
> > > </IPermission>
> > > </PermissionSet>
> > > </Assembly>
> > >
> > > <Default>
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution"
> > > />
> > > </PermissionSet>
> > > </Default>
> > > </CustomAssemblies>
> > >
> > >
> > > And the policy file rssrvpolicy.config is also modified:
> > >
> > > <CodeGroup class="UnionCodeGroup"
> > > version="1"
> > > PermissionSetName="FullTrust"
> > > Attributes="LevelFinal"
> > > Name="cmcs.wsclient"
> > > Description="Codegroup generated by the .NET Configuration
> tool">
> > > <IMembershipCondition class="UrlMembershipCondition"
> > > version="1"
> > > Url="file://C:/Program Files/Microsoft SQL
> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > > </CodeGroup>
> > >
> > > Any tips?
> > >
> > > Jonas
> > >
> > >
> > >
> >
> >
>|||Yes, I also had a heck of a time with this. We are calling a web service to
translate English to Spanish.
I ended up going the FullTrust route myself, still haven't tested on a clean
machine all the install and config steps I took.
Steve
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ejM$u7RIGHA.376@.TK2MSFTNGP12.phx.gbl...
> I've finally gotten the report to run in Report Server, but it took a
> while
> and a nasty config to do it. It seems that the only way to get this to
> work
> is to change the PermissionSet for Report_Expressions_Default_Permissions
> in
> rssrvpolicy.config to FullTrust. I've tried to create a custom
> PermissionSet
> with CASPOL where I ended up adding all permissions and setting them to
> Unrestricted="true" thinking that I could then remove one at a time to
> finally get a lower priviliege permission set, but the only thing that
> works
> is FullTrust.
> Is there someone else that have experienced the same thing?
> Brgds
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
>> After some more investigation, I found out that it is the following
>> statement
>> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
>> I need this to get the web services to use the callers identity. The
>> exception thrown is:
>> Request for the permission of type
>> System.Security.Permissions.EnvironmentPermission
>> As before, it works in Report Designer so the code is alright, it is the
>> security configuration that fails somewhere.
>> /Jonas
>> "Jonas" <Jonas@.nospam.pl> wrote in message
>> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> > I forgot to mention that I make an assert in code before the call to
>> > the
>> web
>> > service:
>> >
>> > WebPermission webPerm = new
>> > WebPermission(PermissionState.Unrestricted);
>> > webPerm.Assert();
>> > TIA
>> >
>> > Jonas
>> >
>> > "Jonas" <Jonas@.nospam.pl> wrote in message
>> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
>> > > Hi,
>> > >
>> > > I've got a custom assembly used in Rptsvcs that calls a web service
>> > > on
>> the
>> > > local host. When run in Report Designer, it works as planned, but
>> > > when
>> run
>> > > in Report Server, it doesn't call the web service. I have a
>> > > HelloWorld-method in the custom assembly that works, so the assembly
> is
>> > > working but it can't call the web service.
>> > >
>> > > I have modified RSReportServer.config as follows:
>> > >
>> > > <CustomAssemblies>
>> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
> Culture=neutral,
>> > > PublicKeyToken=xxx">
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution, Assertion"
>> > > />
>> > > <IPermission
> class="System.Security.Permissions.WebPermission"
>> > > version="1">
>> > > <ConnectAccess>
>> > > <URI uri="$OriginHost$"/>
>> > > </ConnectAccess>
>> > > </IPermission>
>> > > </PermissionSet>
>> > > </Assembly>
>> > >
>> > > <Default>
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution"
>> > > />
>> > > </PermissionSet>
>> > > </Default>
>> > > </CustomAssemblies>
>> > >
>> > >
>> > > And the policy file rssrvpolicy.config is also modified:
>> > >
>> > > <CodeGroup class="UnionCodeGroup"
>> > > version="1"
>> > > PermissionSetName="FullTrust"
>> > > Attributes="LevelFinal"
>> > > Name="cmcs.wsclient"
>> > > Description="Codegroup generated by the .NET Configuration
>> tool">
>> > > <IMembershipCondition class="UrlMembershipCondition"
>> > > version="1"
>> > > Url="file://C:/Program Files/Microsoft SQL
>> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
>> > > </CodeGroup>
>> > >
>> > > Any tips?
>> > >
>> > > Jonas
>> > >
>> > >
>> > >
>> >
>> >
>>
>|||When the report is deployed and run from the web server it runs under a
different set of user credentials to when it is in debug, (Probably "Local
System" or "Network Service", which ever user is configured to run the
reporting services?).
Try explicitly setting the network credentials like so..
ws.Credentials = new NetworkCredential(Username, Password, Domain);
I actually store my username/password/domain in a Settings file, to allow it
to be changed easliy.
This works for me when calling the reporting services web service, I am using:
1. Explicit credentials of a domain user that can access the web service,
2. set the rssrvpolicy.config, Report_Expressions_Default_Permissions -->
Full_Trust
Note I am running my assembly in the gac.
Hope this helps
John