Skip to Content
author's profile photo Former Member
Former Member

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

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 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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 20, 2006 at 04:54 PM

    Hi L D,

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


    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,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.