“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.