We are currently working with SSRS R2 and SharePoint 2010. SharePoint 2010 has been deployed a multitenant solution. SharePoint and SSRS are on separate servers. We have successfully integrated the two products but are experiencing some
The SharePoint site we are deploying to uses a port number (e.g.
http://mysharepointsvr:2222). When you launch Report Builder from this site, it does not open connected to a Report Server. When you try to connect to a Report Server the obvious choice is to put in
http://mysharepointsvr:2222 for the Report Server service. However, this does not work. We are getting the following error:
Connection Failed. Unable to connect to the server that is specified in the URL, 'http://mysharepointsvr:2222'. Make sure the server is running, the URL is correct, and you have permission to use the server.
However, if we use the SharePoint address without the port number it will connect. This does not work as the SharePoint port determines which site we are directed to for resources. In our case, we need to be able to browse the folders on port
2222 not port 80 (default).
As far as the error above is concerned, we are able to browse to the report server (http://sql101/reportserver) and see all of the SharePoint sites. In all cases, identical credentials are being u
View Complete Post