Deserialization failed: The element has invalid child element

a) how do I know which version of SSRS designer I have? how do I know
which version is current?
b) anyone know what this means:
c:\documents and settings\administrator\my documents\visual studio
projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
\takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
Deserialization failed: The element 'http://schemas.microsoft.com/
sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
(571, 23).On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
wrote:
> a) how do I know which version of SSRS designer I have? how do I know
> which version is current?
> b) anyone know what this means:
> c:\documents and settings\administrator\my documents\visual studio
> projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> Deserialization failed: The element 'http://schemas.microsoft.com/
> sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> (571, 23).
In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
Studio' to get the version number, service pack, etc. Don't quote me
on this, but I believe that the latest version is 9.0.3042.
This thread may offer some insight into your error:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/232cb81b9f1f1328/5bb841311ab856ac?lnk=st&q=The+element+%27http%3A%2F%2Fschemas.microsoft.com%2Fsqlserver%2Freporting%2F2003+has+invalid+child+element&rnum=1#5bb841311ab856ac
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I meant for SQL 2000 on the version thing
I've got 8.0.0.760 on the visual studio side.. or something around 700
I assume that this is not SP2 for SSRS 2000?
On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> wrote:
> > a) how do I know which version of SSRS designer I have? how do I know
> > which version is current?
> > b) anyone know what this means:
> > c:\documents and settings\administrator\my documents\visual studio
> > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > Deserialization failed: The element 'http://schemas.microsoft.com/
> > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > (571, 23).
> In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> Studio' to get the version number, service pack, etc. Don't quote me
> on this, but I believe that the latest version is 9.0.3042.
> This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Apr 4, 11:45 am, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
wrote:
> I meant for SQL 2000 on the version thing
> I've got 8.0.0.760 on the visual studio side.. or something around 700
> I assume that this is not SP2 for SSRS 2000?
> On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> > On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> > wrote:
> > > a) how do I know which version of SSRS designer I have? how do I know
> > > which version is current?
> > > b) anyone know what this means:
> > > c:\documents and settings\administrator\my documents\visual studio
> > > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > > Deserialization failed: The element 'http://schemas.microsoft.com/
> > > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > > (571, 23).
> > In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> > Studio' to get the version number, service pack, etc. Don't quote me
> > on this, but I believe that the latest version is 9.0.3042.
> > This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You should be using either SP3 or SP3a, according to your version.
This link should be useful:
http://support.microsoft.com/kb/321185
Regards,
Enrique Martinez
Sr. Software Consultant|||yeah.. but that is the SP for the database-- not for the reporting
services side
I'll find it soon I guess
thanks
On Apr 4, 11:07 am, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Apr 4, 11:45 am, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> wrote:
>
>
> > I meant for SQL 2000 on the version thing
> > I've got 8.0.0.760 on the visual studio side.. or something around 700
> > I assume that this is not SP2 for SSRS 2000?
> > On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> > > On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> > > wrote:
> > > > a) how do I know which version of SSRS designer I have? how do I know
> > > > which version is current?
> > > > b) anyone know what this means:
> > > > c:\documents and settings\administrator\my documents\visual studio
> > > > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > > > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > > > Deserialization failed: The element 'http://schemas.microsoft.com/
> > > > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > > > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > > > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > > > (571, 23).
> > > In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> > > Studio' to get the version number, service pack, etc. Don't quote me
> > > on this, but I believe that the latest version is 9.0.3042.
> > > This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> > > Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> You should be using either SP3 or SP3a, according to your version.
> This link should be useful:http://support.microsoft.com/kb/321185
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -

Deployment Error

I am getting the following error when deploying to the Sharepoint from my Report Designer. I was able to deploy the reports before by providing the TargetServer url. What could be going wrong?

The path of the item "/Sample Reports/Test Sample Report " is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply.

Very wiered... I was able to deploy the report even with deployment error... Any way I changed the name of the report and am not getting any deployment errors.

Deploying from VB.NET Report Designer to Report Server fails

quote:

---

>--Original Message--
>I would like to know what protocol / port Report Designer

---

uses when performing the "Deploy " function from the IDE
of Report Designer. For some reason it cannot connect with
the report server. I can browse the /rs/reportserver
directory and can upload the RDL file through the IE.

quote:

---

>This is probably some kind of security related issue, but

---

I need to know what to look for...

quote:

---

>Thanks
>.
>

---

I believe reporting services-type issues should be posted
here; microsoft.public.sqlserver.reportingsvcs (although
to be fair the newsgroup isn't available via the HTML
viewer).
Having said that, when you 'deploy' an RS report all its
doing is posting XML (ie the RDL) to a web site (in this
case a web service) so the protocol is HTTP and the port
is usually 80. The fact that you can browse to the
directory and upload using the Report Manager suggests to
me that the problem is with your VS config. In the report
project properties check that you've set
the 'TargetServerURL' for the RS web service correctly.Thank you for your comment. The TargetServerURL is correct. It was working u
ntil the headquarters IT changed some kind of security policy, blocking spec
ific ports. I do not know thus which port the Report Server is listening for
the RDL files.
Thanks.
MP|||The Report Server is a web service so it is listening on port 80. Can you
connect to the URL directly? We should move the discussion over to the
reporting services newsgroup.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Minas Papageorgiou" <anonymous@.discussions.microsoft.com> wrote in message
news:92DC3C18-5F09-4366-AA80-38DE26B879E9@.microsoft.com...
> Thank you for your comment. The TargetServerURL is correct. It was working
until the headquarters IT changed some kind of security policy, blocking
specific ports. I do not know thus which port the Report Server is listening
for the RDL files.
> Thanks.
> MP
>|||I'm having the same problem.. I can browse to the target url fine, but I ca
n't deploy from IDE. I can open a browser and upload the RDL through the we
b interface from the same machine. I've verified target URL is correct. I
can't find any mesages in t
he client event log or the server event log indicating what the problem migh
t be... suggestions?|||What is the message you get in the Report Designer? Are you using HTTP or
HTTPS?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:4F51D39A-BEAC-43AB-817A-D894CBB0A74E@.microsoft.com...
> I'm having the same problem.. I can browse to the target url fine, but I
can't deploy from IDE. I can open a browser and upload the RDL through the
web interface from the same machine. I've verified target URL is correct.
I can't find any mesages in the client event log or the server event log
indicating what the problem might be... suggestions?

Deploying Data Processing Extension to Report Designer

I have a problem getting my reports working in the designer in vs.net
2005. I have migrated a sql server 2000 report server project to 2005
and added my custom data processing extension to the config files. The
reports works in the report server but although I have added data
extension to both RSReportDesigner.config and given it full trust in
RSPreviewPolicy.config in much the same way as in the reportserver
config files I cant get it to work.
This is my entry in the RSReportDesigner.config in the Data Section:
<Extension Name="HM_SQL_3"
Type="HM.IPS.Report.DataExtension.PermissionProvider.Connection,
HM.IPS.Report.DataExtension"/>
And this is my entry in the RSPreviewPolicy.config:
<CodeGroup class="UnionCodeGroup" version="1"
PermissionSetName="FullTrust" Name="HM_IPSPermission3"
Description="Group for HM DataExtension3">
<IMembershipCondition
class="UrlMembershipCondition" version="1"
Url="C:\Program Files\Microsoft Visual
Studio 8\Common7\IDE\PrivateAssemblies
\HM.IPS.Report.DataExtension.dll"/>
</CodeGroup>
and I still get :
an attempt has been made to use a data extension 'HM_SQL_3' that is
not registered for this report server
when I try to preview reports.
Does anyone have any idea what to try next? This worked flawlessly in
vs.net 2003 and as mentioned before it works when I use the Report
Server through the web.On Apr 11, 6:52 am, jonas.rosqv...@.ecru.se wrote:
> I have a problem getting my reports working in the designer in vs.net
> 2005. I have migrated a sql server 2000 report server project to 2005
> and added my custom data processing extension to the config files. The
> reports works in the report server but although I have added data
> extension to both RSReportDesigner.config and given it full trust in
> RSPreviewPolicy.config in much the same way as in the reportserver
> config files I cant get it to work.
> This is my entry in the RSReportDesigner.config in the Data Section:
> <Extension Name="HM_SQL_3"
> Type="HM.IPS.Report.DataExtension.PermissionProvider.Connection,
> HM.IPS.Report.DataExtension"/>
> And this is my entry in the RSPreviewPolicy.config:
> <CodeGroup class="UnionCodeGroup" version="1"
> PermissionSetName="FullTrust" Name="HM_IPSPermission3"
> Description="Group for HM DataExtension3">
> <IMembershipCondition
> class="UrlMembershipCondition" version="1"
> Url="C:\Program Files\Microsoft Visual
> Studio 8\Common7\IDE\PrivateAssemblies
> \HM.IPS.Report.DataExtension.dll"/>
> </CodeGroup>
> and I still get :
> an attempt has been made to use a data extension 'HM_SQL_3' that is
> not registered for this report server
> when I try to preview reports.
> Does anyone have any idea what to try next? This worked flawlessly in
> vs.net 2003 and as mentioned before it works when I use the Report
> Server through the web.
This link might be helpful (refer to Bryan E's final response):
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/e1289b66066a07b9/0ba37f7653d8a851?lnk=st&q=an+attempt+has+been+made+to+use+a+data+extension+that+is&rnum=1#0ba37f7653d8a851
Regards,
Enrique Martinez
Sr. Software Consultant

Deployed Report Fials with Multiple Pages

Using SQL RS 2000
My report runs fine in the designer but when deployed to the server it will
only display the first page. When move to page 2 or the last page it gives
the error:
"An unexpected error occurred in Report Processing. (rsUnexpectedError) "
Also, the report calls a subreport and if I remove the subreport it works
fine.
Any ideas?
ThanksI am having a very similar problem in RS 2005.
When I include a subreport, the main report will only display the first page
(correctly) but gives me the same error when navigating to another page.
This is occurring on one particular report only so far - a reasonably
complex report.
I have raised a technical support issue with Microsoft but they have not yet
been able to solve it.
Colin
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:O$Ek5eGgGHA.3996@.TK2MSFTNGP03.phx.gbl...
> Using SQL RS 2000
> My report runs fine in the designer but when deployed to the server it
> will only display the first page. When move to page 2 or the last page it
> gives the error:
> "An unexpected error occurred in Report Processing. (rsUnexpectedError) "
> Also, the report calls a subreport and if I remove the subreport it works
> fine.
> Any ideas?
> Thanks
>

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

Deploy a data source via Report Manager

You can deploy both reports and the data sources used by
them in Report Designer. You can also deploy reports by
uploading them in Report Manager. But I can't find a way
to deploy data sources (not creating new data sources)
using Report Manager.
Ideally, when the developers have finished designing and
testing reports, I'd like to have them sending me both rdl
files and rds files so that I can deploy them into
production.
Can I deploy data sources using Report Manager?
JoeHi, data srouces are files with the .rds extension. I think you can deploy
them by uploading them using report manager.
Cédric
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:86a501c4783b$85c5e8c0$a401280a@.phx.gbl...
> You can deploy both reports and the data sources used by
> them in Report Designer. You can also deploy reports by
> uploading them in Report Manager. But I can't find a way
> to deploy data sources (not creating new data sources)
> using Report Manager.
> Ideally, when the developers have finished designing and
> testing reports, I'd like to have them sending me both rdl
> files and rds files so that I can deploy them into
> production.
> Can I deploy data sources using Report Manager?
> Joe
>|||If you upload a rds file using Report Manager, you just get a file, not a
data source. Are you sure that'll work?
Joe
"Cédric Naudy" <cnaudy@.online.microsoft.com> wrote in message
news:OaWljfKeEHA.332@.TK2MSFTNGP09.phx.gbl...
> Hi, data srouces are files with the .rds extension. I think you can deploy
> them by uploading them using report manager.
> Cédric
> "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> news:86a501c4783b$85c5e8c0$a401280a@.phx.gbl...
> > You can deploy both reports and the data sources used by
> > them in Report Designer. You can also deploy reports by
> > uploading them in Report Manager. But I can't find a way
> > to deploy data sources (not creating new data sources)
> > using Report Manager.
> >
> > Ideally, when the developers have finished designing and
> > testing reports, I'd like to have them sending me both rdl
> > files and rds files so that I can deploy them into
> > production.
> >
> > Can I deploy data sources using Report Manager?
> >
> > Joe
> >
>|||Sorry, this is not supported. You cannot create a shared data source on the
server by uploading an RDS file.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:O46PeAQeEHA.3792@.TK2MSFTNGP09.phx.gbl...
> If you upload a rds file using Report Manager, you just get a file, not a
> data source. Are you sure that'll work?
> Joe
> "Cédric Naudy" <cnaudy@.online.microsoft.com> wrote in message
> news:OaWljfKeEHA.332@.TK2MSFTNGP09.phx.gbl...
> > Hi, data srouces are files with the .rds extension. I think you can
deploy
> > them by uploading them using report manager.
> >
> > Cédric
> >
> > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > news:86a501c4783b$85c5e8c0$a401280a@.phx.gbl...
> > > You can deploy both reports and the data sources used by
> > > them in Report Designer. You can also deploy reports by
> > > uploading them in Report Manager. But I can't find a way
> > > to deploy data sources (not creating new data sources)
> > > using Report Manager.
> > >
> > > Ideally, when the developers have finished designing and
> > > testing reports, I'd like to have them sending me both rdl
> > > files and rds files so that I can deploy them into
> > > production.
> > >
> > > Can I deploy data sources using Report Manager?
> > >
> > > Joe
> > >
> >
> >
>