I am creating reports using SQL business intelligence 2008.
Connection string ‘‘.
And i have created a data set using the below xml query.
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)”.