We upgraded to SSRS 2008 R2 from an SSR2008 example. It was an upgrade in one place and therefore the reports and data sources were brought to the new instance.
From the application side (asp.net), we use SSRS Webservice (ReportService2005.asmx) to make calls such as ListChildren, GetPolicies, to handle some application-specific scenarios.
However, after upgrading to R2, the list service fails to list the web service with "401, inappropriate" message
Reporting Services 2005 Report Service = New Reporting Services (2005); ReportService.Url = ConfigurationManager.AppSettings ["ReportServerWebserviceUrl"]; ReportService.Credentials = New Network Credentials (Configuration Manager. AppSettings ["ReportViewerUser"], ConfigurationManager.AppSettings ["ReportViewerPassword"], Configuration Manager. AppSettings ["ReportViewerDomain"]); ReportService.PreAuthenticate = true; SSRSReportServer.CatalogItem [] _reportItems = New SSRSReportServer.CatalogItem [] {}; _reportItems = reportService.ListChildren (Configuration Manager. AppSettings ["RootFolder"], True);
The code in the asp.net app is in the form above, the account being used in the above network credentials is active and I have checked to ensure that the account is not locked
There is an account setup in the SSRS account as the Account Manager that is trying to use the code.
When I browse - I can see wdsl for webservice
Overall, this code is working, when an Sql2008 SSRS is indicated for example - and the 401 error is shown on the Sql2008 R2 example.
Any thoughts?
Does your web server set to use delegation for your SQL2008 instance, but Not your R2 examples? Since you have set credentials on the web server, this can not be a problem, but this is a very common problem.
Comments
Post a Comment