SSDT/SSRS - Report Previewer Won't Run

Question

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.

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 1

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.

Answer 2

The Preview issue was resolved for me when I deleted the .DATA files associated with the solution.

Answer 3

This can happen when you have some SQL Services installed and running on your machine that interfere with the Report Preview. You can check your current services by going opening Sql Server Configuration Manager:

To fix this you can do the following:

1. Type WinKey + R, input services.msc in the Run box, and press Enter.
2. Find the "Net.Pipe Listener Adapter" and either Restart or Disable it.
   

The workaround, as SQLnbe mentioned, is to:

1. Right Click the RDLC file from solution explorer
2. Click "Run" from there which will open up a new window.