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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

SQLServer 2008 R2 Reporting Service websevice url does not display with custom authentication

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 

Hi:

I have installed SQLServer2008R2(CUD3) (64bits on Windows7) Reporting Service with custom authentication.  I can log in to the report server and report manager and everything appears fine, but the webservice url: http://myhost/ReportServer/ReportService2005.asmx no longer works (The webservice url did display before I put int custom authentication).  I got a html back with error message.

This webservice url used to be not protected.  I wonder if this is something changed in 2008R2 and it is a bug, or something I did not do it right.

 

Thanks for any help!

<html>
    <head>
       // some info here

</head>

    <body bgcolor="white">

            <span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

            <h2> <i>Access is denied.</i> </h2></span>

            <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "


View Complete Post


More Related Resource Links

WCF service IIS7 Server 2008 custom User Name Authentication performance

  

Hi

I have WCF service. Nothing special. Everithing from "best-practice".

  • WCF Service hosted on Server2008(64)\IIS7
  • Application pool - integrated\.NET 4.0
  • binding: basicHttpBinding; security:TransportWithMessageCredential
  • transport clientCredentialType="None"
  • message clientCredentialType="UserName
  • custom class inherited from UserNamePasswordValidator provide simple validation.

Everything works as designed. But I have a performance issue.

I traced and logged the server and WCF class and figured out that there is no new "http request" in process until previous one passed "Verification". It looks like concurrent calls do not have any sense because UserName Password Validator may serve them one by one only.

It can't be a true. I hope I just missed some settings.

I will appreciate any help.

Thanks


SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services

  

SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.

James Yip

MSDN Magazine February 2005


Windows service can't use Reporting Services on SQL Service 2008 R2

  
Hello. I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service. When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report. After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use Reposting Services again. What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?   - Per

Parallel Groupings are not showing the data in Reporting Service 2008.

  
Hi All, My main goal is to show rows under two adjecent groups (say A another one is B) which have one parent group lat call it as AB (all are row sections) and i have one column group for "months".The details inside the group A under the "months" group is not showing any values or expressions it returing me blank. Adjacent groups in SSRS 2008 still shows blank lines for invisible rows (why?). Any ideas.Please let me know. Veeren.

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

  
Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

SSRS 2008 Custom Authentication works when using ReportServer url but not when report manager url is

  
Hi, I am using SSRS 2008 with Custom security extension for authentication. The extension is developed in c#. I have placed the dll under report server bin and report manager bin directory and the logon,login pages under appropriate directory. My reports manager url is http://localhost:port/Reports and my reports server url is http://localhost:port/ReportServer. When I try to login through reports manager url, I am getting 'login failed' error message from the dll. But when I try to login using reports server url, it works. I have also set 'FullTrust' named permission set in RSMgrPolicy.config . <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="FullTrust" Description="This code group grants MyComputer code Execution permission. "> < IMembershipCondition class = " ZoneMembershipCondition " version = " 1 " Zone = " MyComputer " /> Any suggestions please!   Thanks!

Custom webpart displaying Reports from Reporting service

  
Hi          I created a report in VS 2008 and deployed to reporting service. Then when I access this report through a custom webpart some of the cell borders are getting disappeared from inside the table control. Even the cell is not getting misaligned within the cell. But the same report when I retrieve through ReportViewer builtin webpart. Its displaying without any issues. How do I fix such issues?

silverlight + WCF Service + Dynamic proxy(custom binding) + basic authentication on iis

  
hi all, I am having an issue with how to get windows identity in silverlight project. Below is my scenario: the silverlight application need to get data from server via WCF service, i used the way that built dynamic proxy at runtime and aslo used custombinding in this case. Now my application need to deploy on iis and chosen "basic authentication" as a authentication mode. Thus i have chosen authentication mode in WCF was " <security authenticationMode="UserNameOverTransport">". At the client side where kind of project is silverlight that i need have to dynamic proxy with custombinding. My question is: In basic authentication how can i get windows identity to set to chanelfactory.Credentials: _channelFactory = new ChannelFactory<TWebService>(this._binding, new EndpointAddress(_endpointAddress));            _channelFactory.Credentials.UserName = new UserNamePasswordClientCredential();            _channelFactory.Credentials.UserName.UserName = "username";            _channelFactory.Credentials.UserName.Password = "password"; actually, i do not want to use Windows a

Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

  
I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server. I am running Report Builder as an Admin under Win7 64bit. All is OK until I attempt a Save of a newly created shared dataset. The error message is: Failed to save dataset "mydataset.rsd" The feature "Shared dataset" is not supported in this edition of Reporting Services. Details: The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services. I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing. Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround?  John Walton  

SQL Reporting Service, Cookies and Forms Authentication

  
Hi, I currently have a instance of SQL Reporting Services that uses custom Forms authentication. When I access the Report Manager through Internet Explorer the Report Manager redirects to my login page, I login and it heads back to the Report Manager and everything works as expected. The problem I'm having is when I use the web service it fails when I call ListItems( ... ). I first create an instance of the service, I then call LogonUser with a username and password, which executes fine, then I call the ListItems which throws an exception similar to: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '<html>  <head>   <title>    SQL Server Reporting Services   </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 10.50.1600.1" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="127" /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace" content="   at Microsoft.ReportingServices.

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!

SQL 2008 Express with Reporting Service

  
My internal url for reporting service works on my SBS 2003 server, but I cannot access this url via the internet. Could anyone help?

SQL Server Reporting Service 2008 R2 - The request failed with HTTP status 401: Unauthorized.

  
I got the error "The request failed with HTTP status 401: Unauthorized." when I call the Reporting Service Web Service.

The code is very simple:

// Initialise the reporting service Web Service

this.RSWebService = new ReportingService2010();

// Pass windos authentication credentials to Web Service

this.RSWebService.Credentials = System.Net.CredentialCache.DefaultCredentials;

// List children

List<CatalogItem> reports = this.RSWebService.ListChildren(folder, false).ToList();

The SQL Server is installed on a different machine (say server A) from the Web server (say server B). We are using Windows Server 2003.

The code work fine for all the scenario below:

i) Run locally (XP) to call the web service on the sql server

ii) Provide the Network Credentials with the username, password, and domain when calling the web service

iii) If the web server and sql server is using same server (i.e. not distributed)

I'm using windows authentication and impersonation. Any idea?


Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

Reporting Service of SQL 2008, BC30494, Line is too long

  

I have a report which is working fine on SQL server 2005 reporting service. Recently I moved it to SQL Server 2008 Reporting service but it returns [BC30494] error, saying "Native Compiler returns error: Line is too long". I am using Visual Studio 2008 BI, just bring rdl of 2005 into a new project. 

Does anybody know about this? Does 2008 implement some limitations on rdl size?

I searched about this issue and changed by short textbox name and no helps. There are some expressions inside the report but I couldn't locate which expression caused this error.

wondering why 2005 version works.

Thanks in advanced.

 


Reporting Services 2008 and Windows Authentication

  

I have been searching through numerous blogs and MSDN/Technet posts for the answer to this but I can't seem to find anything concrete other than 'do something different.'

 

What I am attempting to do is setup reporting services to do a double hop when using Windows Authentication back to remote datasources.  Here are the scenarios I am faced with so far;  To the best of my knowledge I have setup the appropriate SPN's for kerberos, the server hosting the application is setup for Delegation, as is the Domain Service Account that RS is running under.  RS is running in native mode, not sharepoint integrated.

 

1) When the rsreportserver.config file is set to use NTLM a user can authenticate back to the report server and a report will return the USERID for as appropriate user.  When making a connection to a remote datasource it tries to authenticate as NT Authority\Anonymous logon.  obviously I am not going to setup the anon logon as a read only account on the server for security purposes.

The Web.config file for the report server is set to impersonate 'TRUE', when setting to false the reports returns a userid of the service account RS is using, and attempts to connect to the remote datasource as the service account.  There would be no way to filter roles for who is able to

Categories: 
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