Integrated Security on Reporting Services XML Datasource

Posted by Nathan on Stack Overflow See other posts from Stack Overflow or by Nathan
Published on 2011-01-07T21:48:06Z Indexed on 2011/01/07 21:54 UTC
Read the original article Hit count: 247

Filed under:

reporting-services

|

windows-authentication

|

kerberos

Hey all,

I am working on setting up my report server to use a web service as an XML datasource. I seem to be having authentication issues between the web service and the report with I choose to use Integrated security. Here's what I have:

1) I have a website w/ an exposed service. This website is configured to run ONLY on Integrated Security. This means that we have all other modes turned off AND Enabled anonymous access turned off under directory security.

2) Within the Web.config of the website, I have the authentication mode set to Windows.

3) I have the report datasource set to being an XML data source. I have the correct URL to the service and have it set to Windows Integrated Security. Since I am making a hop from the Browser to the Reporting Server to the Web Service, I wonder if I am having an issue w/ Kerberos, but I am not sure.

When I try to access the service, I get a 401 error.

Here are the IIS logs that I am generating:

2011-01-07 14:52:12 W3SVC IP_ADDY POST /URL.asmx - 80 - IP_ADDY - 401 1 0 2011-01-07 14:52:12 W3SVC IP_ADDY POST /URL.asmx - 80 - IP_ADDY - 401 1 5

Has anyone worked out this issue before? Thanks!

© Stack Overflow or respective owner

Related posts about reporting-services

Subtotal error on calculated field in a Reporting Services Matrix

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB. I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to… >>> More
Reporting Services: Two Tables One Sum

as seen on Stack Overflow - Search for 'Stack Overflow'
My report is as follows: One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data) The second table is a variance report for data that has been shipped… >>> More
Sharepoint/WSS Reporting Services Integration woes

as seen on Stack Overflow - Search for 'Stack Overflow'
after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the only additional functionality available is the report… >>> More
SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

as seen on Server Fault - Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. Error Code 800706B3 This error appears before I can even attempt to connect to an SSRS instance. In… >>> More
SQL Server Reporting Services Data Extention

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! So... here's my story: I'm trying to create a SQL server data extension (to be precise, I'm trying to get some sample code to run) (SSRS2005). I've done the following: Placed the extension assembly into the ReportServer/bin folder. Placed the assembly into the Private Assemblies folder… >>> More

Related posts about windows-authentication

Set up basic Windows Authentication to connect to SQL Server 2008 from a small, trusted network

as seen on Server Fault - Search for 'Server Fault'
I'm guessing that this is documented somewhere on Microsoft's site, but thus far I haven't found it. I'm trying to set up a Windows Server 2008 box to have SQL Server 2008 with Windows Authentication (Mixed Mode, actually, but anyway) for work. We have a number of client machines that will need… >>> More
Disable authentication on subfolder(s) of an ASP.NET app using windows authentication

as seen on Server Fault - Search for 'Server Fault'
Hi, Is it possible to disable windows authentication on one or more subfolders of an ASP.net application using windows authentication? >>> More
windows authentication vs sql server authentication for asp.net forms authentication site

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database and a site having forms authentication. It is working fine with VS2008. This time, I am using "Trusted_connection =True". But when it is opened from outside or directly from browser then I am getting error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." I know this is due… >>> More
the best way to connect sql server (Windows authentication vs SQL Server authentication) for asp.net

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database and a site having forms authentication. It is working fine with VS2008. This time, I am using "Trusted_connection =True". But when it is opened from outside or directly from browser then I am getting error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." I know this is due… >>> More
IIS: Anonymous and WIndows Authentication

as seen on Stack Overflow - Search for 'Stack Overflow'
Scenario For a multiple file uploader I am implementing, I need to have a handler within a windows authenticated site that uses anonymous access. As detailed here, this is because Flash cannot use windows authentication. The aforementioned post states that the only way to accomplish this is to… >>> More