I have a requirement in which i have to generate reports (using SSRS) with my Sharepoint list as Data Source.
This can be done by consuming the web services in my SSRS, by providing the connection string and Type = XML.
My connection string when browsed in browser, "http://<server name>/_vti_bin/lists.asmx" gives me the *method lists* in the <server name>.. which is fine.
However when this is used in my DataSource in SSRS, i get the following error:"You might not have permission to view this directory or page using the credentials that you supplied. The Web server has a filter installed to verify users connecting to the server and it failed to authenticate your credentials."
In the credentials tab, i am using the "Windows Authenticated"
Any help is highly appreciated. :)
View Complete Post