Web service as dadatource with basic authentication

Is it possible to configure a datasource using data from a web service (java) requiring basic http authentication?

 thank you in advance

August 2nd, 2011 2:41pm

Hi SwissSeb,

Reporting Services is a comprehensive reporting tool that integrates with a diverse set of data sources. We can also query directly from XML data sources and Web services. This is obtained by using the XML data provider. The XML data provider flattens the XML structure into a data set that can be accessed by the reporting engine. Please refer to this whitepaper which concludes with examples showing how to create reports using the XML data provider http://technet.microsoft.com/en-us/library/aa964129(v=sql.90).aspx 

Thanks,
Challen Fu

Forum Support
If you have feedback for TechNet Subscriber Support, please contact us

Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2011 5:49am

Thank you for your reply.
The procedure I followed it exactly and this is my observation:

If the web service is used with anonymous authentication, no problem
configuration : Shared data Source Properties > Credentials > Do not us credentials


If the web service requires basic authentication, I tried two configurations:
configuration 1 : Shared data Source Properties > Credentials > Use this user and password
configuration 2 : Shared data Source Properties > Credentials > Prompt for credentials

it does not work I have the following message :
An error occurred while connecting to the data source … The data extension supports Windows Integrated Security and No Credentials only.

I conclude that I can not call a web service with basic authentication in this way.

Is there a workaround?

August 3rd, 2011 7:18am

Hi SwissSeb,

You are correct, from a report which retrieve data source from Web services, when authoring client, the following options are available to specify credentials:

·         Current Windows user (also known as integrated security).

·         No credentials are required.

If you select no credentials, Anonymous access is used. Make sure that you have defined the unattended execution account for the report server to connect to an external data source. The XML data processing extension does not pass credentials to the target URL or the Web service; the connection will be unsuccessful unless you have defined the unattended execution account. For more information, see Configuring the Unattended Execution Account in the Reporting Services documentation

Stored and prompted credentials are not supported. If you disable Windows integrated security, you cannot use it to retrieve data. If you specify stored or prompted credentials, an error will occur at run time.

However here I still would recommend you to submit a feedback to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

Fore more information about credentail for XML Connection Type, please see: http://msdn.microsoft.com/en-us/library/dd220468.aspx

Regards,
Challen Fu

Free Windows Admin Tool Kit Click here and download it now
August 4th, 2011 3:27am

Hi

Any news on this from Microsoft? I need SSRS to report from various WEB Services that require http authentication. The current XML data provider for SSRS does not support this basic requirement?

Regards

June 10th, 2015 1:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics