Question Re: getting BW data using SAP web services from a MS .Net app using XMLA in Technology Q&A

getting BW data using SAP web services from a MS .Net app using XMLA

Former Member — Wed, 20 Dec 2006 16:14:29 GMT

Hello everyone,

Here is the situation. We have a MS .Net app that uses a MS AnalysisServices AdomdClient connection to try to use the SAP web services to get data from BW. The connection.open is failing with this error:

Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.

This worked fine as long as anonymous access was enabled. As soon as it was disabled and we switched to connecting with a username and password in addition to the data source, it fails. We have been "assured" that this username has full access but it would seem that it does not. We are using port 1080.

Thank you for any assistance and advice on how to resolve this problem.

Re: getting BW data using SAP web services from a MS .Net app using XMLA

Andre_Fischer — Wed, 20 Dec 2006 16:54:11 GMT

Hi L D,

maybe you can try out the method I have been describing in my blog.

/people/andre.fischer/blog/2006/11/05/single-sign-on-of-windows-based-web-service-clients-using-sap-logon-tickets

You can change the coding such that instead of using Windows Integrated Authentication for the initial authentication you use username and password. (You will find it as a comment in the coding).

Best regards,

André

Re: getting BW data using SAP web services from a MS .Net app using XMLA

Former Member — Mon, 08 Jan 2007 16:00:57 GMT

Thank you so much for your assistance.