The remote server returned an error: (401) Unauthorized. Failed to execute web request for the speci

Hi,

I am creating reports using SQL business intelligence 2008.

Connection string ‘http:///_vti_bin/lists.asmx ‘.

And i have created a data set using the below xml query.


   http://schemas.microsoft.com/sharepoint/soap/GetListItems
   http://schemas.microsoft.com/sharepoint/soap/ ” Name=”GetListItems”>
     
        
            {GUID of the list}      

        
      

     

  

   *

 

When I try to execute this on the Query builder, I got this error.

The remote server returned an error: (401) Unauthorized.
—————————-
Failed to execute web request for the specified URL.
Unauthorized: The remote server returned an error: (401) Unauthorized.

But when the same thing I tried in  SQL business intelligence 2005, it works. I can able to get all the field values. This is extremely strange thing.

Works in 2005, but not in 2008. Does anyone knows why this happens and what’s wrong with this.

Hi EstoySol,Based on the error  message, this should be permission issue. Firstly, you try to access the connection string using IE. If it can be accessed, you can solve this issue by changing the Datasource credential to “Use Windows Authentication(integrated security)”.