“The target location you specified is not supported by the report server” message when configuring SSRS in SharePoint Integrated mode

 

Client kept getting “The target location you specified is not supported by the report server” message every time they try to run a SQL 2005 report manually deployed to SharePoint document library (MOSS). This same error also showed up when we go to “Set Server Defaults” (in the top section) page in Central Admin .

 

This same report worked fine when a subscription is enabled and the subscription runs in un-attended mode.

 

Within “Manage Integrated settings” page, the authentication mode is set to “trusted account” as Kerberos is not enabled.

 

The cause for this message was because there was another Alternate Access Mapping (AAM) set up for Central Admin.

 

Once the extra AAM was removed, the error disappeared and issue was resolved.

 

Here is the link that helped resolve this issue https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2991956&SiteID=1

 

Per Shawn Feldman (a colleague of mine), the reason for this is due to Reporting Services in SharePoint Integration mode does not support multiple zones. That’s why it errors out when one has a second AAM.

Comments

• Anonymous
  February 22, 2010
  Hi all, This error also occurs when the 'Action' property is set to 'Go To URL' for a textbox (in SSRS) but only when a document/ page link is external to the MOSS site or if the page is not in a child folder.   For example, in a SSRS report, if you want to display text, from a table, that has a list of products and you have links to them i.e. the text 'CPU 1.4GHz' has a clickable link to 'http://www.example.com/productid=1345'; the report wont work in MOSS and you will get the error: "The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it." If you use back slashes after http: (i.e. http:' or 'http:\www.example.com/productid=1345') then MOSS will display your external document/ page. Hope this workaround helps. Shaheen

• Anonymous
  April 06, 2010
  Thank you so much for posting this simple workaround.  I had spent hours trying to figure out what was wrong!  When I changed to back slashes as you suggested, it worked fine.  Thanks again!

• Anonymous
  June 05, 2010
  Hello, Thats no problem! - Im glad it helped! :) Shaheen

• Anonymous
  May 16, 2011
  Thanks for the backslash workaround.  I have no idea why that works but it does!

• Anonymous
  March 07, 2012
  I have also been baffled by this for the last day trying all sorts of things to resolve it and the simple backslashes worked a treat!!  Many thanks :-)