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

[Former Member]

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.

[Andre_Fischer]

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é

[Former Member]

Thank you so much for your assistance.