SSDT/SSRS - Report Previewer Won't Run

reporting-services sql-server-data-tools
Matt Koster picture Matt Koster · Aug 7, 2014 · Viewed 13.7k times · Source

I'm having a very peculiar issue with SQL Server Data Tools 2012. Whenever I attempt to launch the report previewer, I get the following exception:

There was no endpoint listening at net.pipe://localhost/PreviewProcessingServce7324/ReportProcessing that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more deatils.

Error Message

As far as I can tell, nothing I did triggered the issue. It just started happening one day when I fired up SSDT. I tried the suggestion on Report Designer Preview in SSDT throws up a 'end point' not found error.

However, my service is up and running just fine (restarting it didn't help), and using Setspn didn't do anything for it, either.

Anyone have any ideas?

Answer

SQLnbe picture SQLnbe · Oct 16, 2014

That is a current bug in SSDT-BI. The current workaround for now is to right click on the report you want to preview in your Solution Explorer and click RUN.

You will also notice that if you try to preview the report for the first time a command prompt window opens up that runs the preview process, If you don't close this window and just minimize it then you can preview the report but I think the RUN method is much easier for now. Please mark as answer if this helped.

Related questions

SSRS error on preview : "The size necessary to buffer the XML content exceeded the buffer quota" hides original error

I understand that there is definitely something wrong with my report (e.g. columns missmatcch) and I need to correct it but what I see is the WCF error message that hides actual problem and exactly this hiding irritates me …

Read More
Cannot import .rptproj in VS2015 - says it's "Unsupported". Latest SSDT is installed

I am trying to convert some older VS2005 projects over to VS2015 Enterprise. When I open any with a report project (.rptproj), VS says the project is unsupported. Unsupported This version of Visual Studio is unable to open the following …

Read More
The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More