SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Revenant / Report Server Web Service / Latest Posts

RE: Report Server Web Service

webrunner — Wed, 14 Apr 2010 12:31:51 GMT

The 2006 threw me off in terms of guessing, but I am not going to lobby for a point because guessing (even if there is a typo) should not be rewarded. :-)Thanks,webrunner

RE: Report Server Web Service

L' Eomot Inversé — Sun, 11 Apr 2010 15:05:34 GMT

I got it wrong. Now I know the answer. So the question was useful to me.

RE: Report Server Web Service

Tom Garth — Fri, 09 Apr 2010 07:10:16 GMT

[quote][b]David Burrows (4/9/2010)[/b][hr]SSRS 2003 does not have any numerical suffix for the endpoint.So technically none of the answers are correct. :-P[/quote]Technically speaking - What is SSRS 2003?:hehe:

RE: Report Server Web Service

David Burrows — Fri, 09 Apr 2010 06:57:55 GMT

SSRS 2003 does not have any numerical suffix for the endpoint.So technically none of the answers are correct. :-P

RE: Report Server Web Service

SQLRNNR — Thu, 08 Apr 2010 10:41:53 GMT

Thanks Hugo for also providing the same feedback that I found from answering this question.I have to admit that it is good to see that there is little contention over the wording (based on history) or the incompleteness of the explanation of the answer.That said, I do believe this is an educational question.

RE: Report Server Web Service

OCTom — Thu, 08 Apr 2010 09:29:47 GMT

Since I hadn't had coffee, yet, I couldn't understand any part of this. That's why I posted ?????. Now, after looking at it again, I do understand it now. Thanks for the question and thanks to all who commented to clear this up for me.

RE: Report Server Web Service

Ray K — Thu, 08 Apr 2010 09:25:05 GMT

Good question. But the 2006 did throw me.I found this in BOL:[quote]There are two endpoints available for managing objects on a report server, ReportService2005 and ReportService2006. The ReportService2005 endpoint is used for managing objects on a report server that is configured for native mode. The ReportService2006 endpoint is used for managing objects on a report server that is configured for SharePoint integrated mode.. . .The WSDL for the management endpoint can be accessed using the following URL:http://<Server Name>/ReportServer/ReportService2005.asmx?wsdl If the report server is configured for SharePoint integrate mode, the WSDL can be accessed using the following URL:http://<Server Name>/<Site Name>/_vti_bin/ReportServer/ReportService2006.asmx?wsdl [/quote]Based on this, it seemed neither of the first two options worked, so I went with the third one by process of elimination.

RE: Report Server Web Service

Revenant — Thu, 08 Apr 2010 09:12:21 GMT

I posted this question to draw attention to the fact that yes, there is such Web Service but the explanation on MSDN is pretty unclear.

RE: Report Server Web Service

Trey Staker — Thu, 08 Apr 2010 09:01:30 GMT

Got it right only because I guessed.

RE: Report Server Web Service

Daniel Bowlin — Thu, 08 Apr 2010 08:06:22 GMT

Although I agree the wording/typos in this question had me a bit confused at first, this was a great question. The best questions IMHO are those that make me want to do more research on the background and broader issues involved in the answer. The answer makes sense to me, but the explanation link makes me want to investigate a lot more. I have the feeling that there is a gap in my knowledge in this area and I will be spending time trying to close that gap.Thanks

RE: Report Server Web Service

KWymore — Thu, 08 Apr 2010 07:33:28 GMT

I had to look this one up because the ReportService2006 answer option seemed incorrect to me. I chose the "correct" answer but only because I figured there was a typo. This is a good question, but missing information.I would either update the question to mention that Sharepoint integrated mode is configured so that option 2 is correct or change option 2 to ReportService2005.asmx as that would be the correct answer if Sharepoint integrated mode is not configured and just the default report server configuration is used.

RE: Report Server Web Service

Tom Garth — Thu, 08 Apr 2010 07:28:48 GMT

[quote][b]Hugo Kornelis (4/8/2010)[/b][hr][quote][b]Tom Garth (4/8/2010)[/b][hr]I stand corrected. After rereading Hugo's answer I may have gottem it right for the wrong reason.So is 2005 the endpoint's port number?[/quote]You'll have to re-reread my post.:-D The name of the endpoint contains either 2005 or 2006, depending on whether the report server is enabled for SharePoint integrated mode.[/quote]I understand it is part of the name. I was just wondering if the name reflected the listening port number.

RE: Report Server Web Service

rjv_rnjn — Thu, 08 Apr 2010 07:21:01 GMT

From the answer I would assume it to be logical that they have put "2005" or "2006" to differentiate between different versions of SSRS. But the BOL shows the same endpoint address for SQL Server 2005 & 2008.

RE: Report Server Web Service

Hugo Kornelis — Thu, 08 Apr 2010 07:16:56 GMT

[quote][b]Tom Garth (4/8/2010)[/b][hr]I stand corrected. After rereading Hugo's answer I may have gottem it right for the wrong reason.So is 2005 the endpoint's port number?[/quote]You'll have to re-reread my post.:-D The name of the endpoint contains either 2005 or 2006, depending on whether the report server is enabled for SharePoint integrated mode.

RE: Report Server Web Service

Tom Garth — Thu, 08 Apr 2010 07:01:27 GMT

I stand corrected. After rereading Hugo's answer I may have gottem it right for the wrong reason.So is 2005 the endpoint's port number?

RE: Report Server Web Service

Tom Garth — Thu, 08 Apr 2010 06:57:31 GMT

Since I already knew that it was 2005 even with 2008 servers, I figured that 2006 was just a typo. So I got it right, and was surprised to see the same typo in the explanation.This was a good QotD because it is valuable information.

RE: Report Server Web Service

OCTom — Thu, 08 Apr 2010 06:46:56 GMT

???

RE: Report Server Web Service

ziangij — Thu, 08 Apr 2010 03:58:36 GMT

knew it was second option... unfortunately clicked on the first one though :(

RE: Report Server Web Service

Hugo Kornelis — Thu, 08 Apr 2010 01:21:26 GMT

A nice question, but the answer is not completely accurate.If you read the explanation in page that is linked to, you'll see that the actual name of the endpoint depends on whether or not the report server is configured for SharePoint integrated mode. If it is, the endpoint uses 2006 in its name, without SharePoint integrated mode, it uses 2005. And since the question did not mention SharePoint integrated mode, I now foresee a whole lot of replies from people demanding their points back (even though, for anyone who doesn't just pick an answer at random, it should have been perfectly obvious what the intended answer is!)Oh, and there is indeed also a "not" missing in option 3. Again, obvious from context. And, again, probably a reason for a lot of whining about wanting points back (as if everyone's pay check depends on the points earned here...)

RE: Report Server Web Service

SQLRNNR — Wed, 07 Apr 2010 22:14:42 GMT

I think that the explanation is a bit lacking in clarity.There are actually two endpoints available. It depends on which endpoint you need to use as to which you would reference.The link in the explanation discusses that, but I think it was missed as a part of the explanation for this question.Also, I think the third option needs to be worded more precisely. I think it is missing a "not" in it.I still got the question correct and learned something. I can just see some complaint arising based on the question, answers and explanation.

RE: Report Server Web Service

Paul White — Wed, 07 Apr 2010 20:50:12 GMT

Heh...bit of a guess - and rewarded with one point!Odd name for it - no doubt there is a reason for the '2006' part...:unsure:

Report Server Web Service

Revenant — Wed, 07 Apr 2010 20:49:04 GMT

Comments posted to this topic are about the item [B]Report Server Web Service[/B]