Apologies for the long post: I have a SharePoint 2013 server with Reporting Services 2014 installed in SharePoint Integrated mode, plus a document library with Reporting Services content types enabled. I have a number of existing reports that have been published to a report folder in the document library which can be viewed without any issues.
The SharePoint server is in one domain (Domain A) but the developers who create the reports (including me) have development laptops that are in a different domain (Domain B).
Until now, we have been deploying reports by uploading a zip file to the SharePoint server and deploying the reports using a custom PowerShell script which also updates shared data source and shared dataset references - this method makes it easy for us to deploy the reports to different environments but is quite time-consuming to package up and run.
To speed up our workflow, we wanted to try deploying the reports to our development server direct from Visual Studio, as the deployment process is much quicker.
I have a Reporting Services project and tried deploying to the document library direct from Visual Studio 2017 using the TargetReportFolder and TargetServerURL properties.
The deployment was successful but on viewing the reports after deployment from my local machine, I got this error message: "Error - for more information about this error navigate to the report server on the local server machine, or enable remote errors".
On logging in to the server (with my credentials for Domain A) and clicking on the same reports, the reports displayed without any errors. The report folder and the individual reports have the same permissions inherited from the root site, and all developers' Domain B logins are members of the Site Owners group (which is required in order to be able to deploy from Visual Studio).
Why do I get an error when trying to view the reports from my local machine but not on the server?