Accessing SQL Report Web Services

Question

Hi,

I am testing an app locally that is built in coldfusion. I have sql report services running and i would like to access reports using cold fusion.

I can only access web services through IE. How can i enable anonymous access to the server so that i could do a simple http request from within coldfusion to grab the report.

Secondly, is there a better way to do this than what i am thinking about?

Answer 1

Anonymous access to Reporting Services isn't recommended, although if you're controlling all the access to the reports through a CF layer, then it should be okay. Just go to the web server hosting RS and tell the website that it should use Anonymous access, running as a particular user (to whom you then grant sufficient permission to access the reports). Saving Data Source credentials would also be worth doing in this environment.

Then, you should be able to use the Web Services layer with the Render command to pull down the HTML for a particular report.

Hope this helps,

Rob

Answer 2

Here is an excellent article to access reporting services from Java. May be this post will be helpful for others, if not you.

http://blogs.msdn.com/b/christophputz/archive/2010/05/07/accessing-ms-reporting-services-with-java.aspx?CommentPosted=true#commentmessage