.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Valid Credentials for Report Execution Web Service

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

I've had an application running for some time which accesses reports via the reportingservices web service.   Recently I had a request to directly stream the reports for download rather than viewing them through the report viewer.  I facillitated this using the reportexecutionservice web service and in testing, everything went fine.  When deployed however, the downloads mysteriously failed to occur.

The issue traced to a 401 unauthorized error, which implies my network credentials were rejected.   Easy, right?  Well, the problem I'm having is that I'm using the same credentials for both the reportingservices web service and the reportexecutionservice web service and I had expected that what was sufficient for one was sufficient for the other. 

The credentials I'm passing are for a user which is a member of the SQLServerReportServerUser group on the machine hosting the web service.  Is this insufficient to run the reportexecutionservice, and if so, what do I need to do to adjust the security permissions of this user to grant them access to reportexecutionservice?

View Complete Post

More Related Resource Links

report definition is not valid



I recently upgraded to VS 2010.  One on of my reports I am getting the following error.  Can someone help?

The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded.

Thank you.

Include a Crystal Report in .NET Web Service for Dynamic In-Memory-Only DataSet



I would like to use Crystal Reports in a .NET web service.  Ultimately I would like to convert my report document to a PDF and then return the PDF as a byte array. 

My .NET DataSet is generated dynamically at run-time.  It consists of four related tables.  Since my DataSet does not have a physical datasource, I created an XML Schema file.  I then added the XML Schema file to the web service project with Add Existing Item. 

A solution for working with a dynamic in-memory DataSet exists for ASP.NET web sites and client-based forms.  I tried to use this method as it is published.  When that didn't work I tried creating the report and XML Schema directly in the web service project, but that also didn't work.


The problem is apparent when you try to set the datasource.......the code bombs on the call to SetDataSource(DataSet) with the message
ex = {"The data source object is invalid."}

Crystal Reports would save me a lot

Enter your credentials to connect to the web service


When trying to publish an InfoPath 2007 form template (as a Content Type), I am getting the following message with a UserName/Password dialog box:
Enter your credentials to connect to the following web service: http://MySitePath/_vti_bin/Webs.asmx

When I enter my credentials, the above dialog box appears again. I have carefully entered my credential. Another thing I noticed that despite this error I see the form got created at the destination library. The only thing is that the Content Type did not get created and hence is not available in the "Site Content Type Gallery".

We are using Sharepoint 2007 enterprise edition. And I have recently published the InfoPath form templates several time as Content type without any issue.


Please help. Thanks........

Is this same as SQL server Reporting Service or else what can we say for these type of report genera

Hi      In my windows application I am generating reports using this steps          1) Creates a stored procedure in the sql server for the required report output          2) In the .Net application add new Item adds a DataSet1.xsd binds the stored procedure to the DataSet1           3) Adds a Report1.rdlc to the application and places the requred fields in the Report1.rdlc          4) Adds a ReportViewer control to a form and binds the Report1.rdlc to the ReportViewer contol and shows the report Is this same as SQL server Reporting Service or else what can we say for these type of report generation 

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

I need syntax help going from a URL to a Report Service Report

Here is the syntaxt I have tried.  It takes me to the Root folder page on the server,  how do I get to the report itself from an html link http://server.net/SSRS_Reports?/Folder1/Folder2/ReportName&rs:Command=Render&rc:LinkTarget=blank Thanks Dave  

IE cannot display the webpage during report execution

Hi. I have a problem with a report having some T-SQL and MDX queries. When I execute it during the working hours I have an error about that Internet Explorer cannot display the web page, but in the other hours the execution is completed successfully. I have a look inside RS log but I cannot find any errors; no timeout is set about report execution inside the Report Manager. Any ideas to solve this issue, please? Many thanks

The report definition is not valid. Details: The report definition has an invalid target namespace

Hi all, I am getting this error message when i try to run the report from VS 2010. It was working fine before the upgradation. why it is not working in VS 2010 and SQL Server 2008. can any one please give me a solution.?  

Issues in GetItemDataSources web service call in 2008 Report Server R2

Hi, I'm using Reporting Services web services endpoint ReportService2005.asmx with 2008 report server R2 and I'm facing some issues in getting the data source names for a report definition using the GetItemDataSources web service. The problem is that the data source names returned are different from the names of the actual data sources on the report server. The report has the following data sources: 0 1 _0 _A Data Source And the names returned by the GetItemDataSources for 2008 report server R2 is: AutoGen_0 AutoGen_1 AutoGen__0 AutoGen__A Data_Source When I make the same calls using a 2005 report server, the names returned are the same as that in the report definition. To summarize, only numeric data source names are changed to "Autogen_<number>"(eg. Autogen_0), data source names beginning with "_" are changed to "Autogen_<data source name>"(eg. AutoGen__A)  and spaces are replaced by an "_".   What is the problem for the data source names returned for 2008 report server R2? Or has there been any change in the way in which report server stores the data source names? Thanks, Kulbhushan Singhal.  

The Sanboxed code execution request was refused because the sandboxed code host service was too busy

I am getting following error when I am running my sandbx solution ona virtual machine. "The Sanboxed code execution request was refused because the sandboxed code host service was too busy to handle the request" I verified  in central admin that my  Usercode service is already running. I also tried to run below script using powershell. $acl = Get-Acl HKLM:\System\CurrentControlSet\Control\ComputerName $person = [System.Security.Principal.NTAccount]"Users" $access = [System.Security.AccessControl.RegistryRights]::FullControl $inheritance = [System.Security.AccessControl.InheritanceFlags]"ContainerInherit, ObjectInherit" $propagation = [System.Security.AccessControl.PropagationFlags]::None $type = [System.Security.AccessControl.AccessControlType]::Allow $rule = New-Object System.Security.AccessControl.RegistryAccessRule($person, $access, $inheritance, $propagation, $type) $acl.AddAccessRule($rule) Set-Acl HKLM:\System\CurrentControlSet\Control\ComputerName $acl Any pointer would be highly appreciated!!  

Get Service status(Services.msc) from different servers with credentials

Hi, In my application I need to get Service status from differnt servers.I used System.ServiceProcess class for implementation.Now,I got service status from my local machine. My current requirement is to get service status from different servers with credentials. Consider I host this webapplication in One server A. I need to get service status of Server B,Server C. We can't install or copy any dll or exe in that server(Server B & Server C)<Webservices also we can't host in Server A &Server B >.But, we have credentials.I tried to pass credentials.But getting errors<authentication problems>. Please help me to do the same. Have any other solutions by dos net sat commands.. It's urgent.Thanks in advance

Job Execution times / statistics report ...

We have several sites (countries if you may call them) and each site has its own set of ERP databases (Progress database). We have designed ETL layers that are open and which can be invoked for each of these sites. On top of the ETL layers, we scheduled the SSIS packages via SQL jobs for each site and scheduled them to run at various times of the day based on the site operating hours. I want to now present the amount of time it takes to copy data from the ERP system into our SQL 2008 Staging and finally into our DataWarehouse. I can manually right click on the SQL jobs and get the timings, however, I want to automate this report so that we can look at it initially weekly and maybe monthly when things start to run smoothly. Any pointers or ideas? I know I can run SQL Profiler and capture the SQL behind this report, would it actually work? ThanksJagannathan Santhanam

how to store credentials with windows authentication in reporting service for subscription

when I try to set up a subscription, I get this error message: "Subscriptions cannot be created because the credentials used to run the report are not stored or if a linked report, the link is no longer valid" I use a datasource which use windows credentials to access a database which contains stored procedure with OpenRowset query to access cube data in analysis service on the same server.  I have to use windows credentials to access cube data in analysis service.  How can I store the credentails with windows credentials? I appreciate your help!

Problems with using SPSite inside a Web Service (presumably credentials problem)

Greetings. I need to write a web service which will access sharepoint via object model (need to output data from lists, and no, built-in sharepoint web services are useless to me since they totally suck if you dont have an english-language site) In the code of my web service, i use something like this:   Site = new SPSite(SiteLink); Web = Site.AllWebs[""]; And then i use Web.Lists to get my list and work with it. It works, unless i put the webservice on. I mean, when the webservice is launched from Asp.net deveopment server, it works fine. When i made a website in IIS pointing it to my webservice, it now spits this error:   System.IO.FileNotFoundException: ?? ??????? ????? ???-?????????? ?? ?????? http://localhost/sites/test/. ?????????, ????????? ?? ?????? URL-?????. ???? ???? URL-????? ???????????? ??? ????????????? ???????м???, ???м????, ?????м??м? ??м??????????? ??????????? ???????? ????? ????????????? URL-?????? ??????? ? ?????м ??????????м. at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, SPUserToken userToken) at Microsoft.SharePoint.SPSite..ctor(String requestUrl) at IstrebitelProperListWebService.SchemaExporter.SetSite(String siteLink) in C:\Users\Administrator\Documents\Visual Studio 2008\Projects\ProperListWebService\ProperListWebService\IstrebitelProperListWebServ

Report Manager Security: If a user login to Report Service than he should be able to see only a fold

Report Manager Security: If a user login to Report Service than he should be able to see only a folder for which he has role assing and rest of the folder should be hidden for him. How this security i can achive with c#

what are valid client credentials in windows auth?

I just finished configuring a service to use net.tcp binding and use security mode of Transport with Windows creds.  Previously I had been using security mode none, but I'm trying to improve things. So this works for client computers that are members of my domain.  But when I try to launch the client on a computer using a local account login that is not a member of the domain, I get "The server has rejected the client credentials". In order for "Transport" mode "Windows" credentials to work, do all clients have to be run from domain authenticated workstations? How can I get my client to run from this non-domain computer?  Its on the same network, but not a member of the domain. -Ethan Nelson

Issue - The report execution has expired or cannot be found. (rsExecutionNotFound)


Hello Experts,

I am running a huge SSRS 2008 report (that returns 2 million records) and it gets rendered sometimes and sometimes it gives me an error,

"The report execution <some string> has expired or cannot be found. (rsExecutionNotFound)”.

When I see SQL Server log after this issue comes I see following message there;

"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"

IMPORTANT point to note here is when I am running reports with 1 million records or smaller than that, then I am able to execute them successfully without any issue.

I am using SSRS 2008 64 bit, Win Server 2003 64 bit. RAM is 8GB.

Please help me to know what are these issue, are these two issues related and how to fix it?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend