CODEWITHSUNDEEP
reporting-servicessql-server-data-tools
Matt Koster
Matt Koster

Reputation: 219

SSDT/SSRS - Report Previewer Won't Run

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?

Upvotes: 10

Views: 18979

Answers (8)

chandu
chandu

Reputation: 1

Just closing the visual Studio by ending task with task manager and re-opening the solution worked for me to get through the error.

Upvotes: 0

Alexandru-Codrin Panaite
Alexandru-Codrin Panaite

Reputation: 734

None of the solution above worked for me. What did I found and it worked is to run Visual Studio as administrator.

Upvotes: 0

George
George

Reputation: 1

This is what I did:

  1. Restart the .Net.Pipe service in the service console. This didn't resolve the issues.
  2. Closed Visual Studio completely and relaunch the Visual Studio 2017 (in my case).

It seem that the preview is back. It could be the combination of (1) and (2).

Upvotes: 0

Mohamed Nasr
Mohamed Nasr

Reputation: 41

I faced the same issue and solved it.

Steps:

  1. Right click on the report.
  1. Click view code.
  1. Check the parameters names in both query parameters and report parameters and make sure it's written correctly.
  1. Close the report and open it again

Thanks

Upvotes: 0

AcePL
AcePL

Reputation: 560

In my case I tried all the above solutions, and:

  1. "Run" from context menu does not really work for me, as it's much, much longer than preview in VS2017, as rendering was a deciding factor in my work (lots of grouping by column etc). and render is much faster in VS compared to SSRS,
  2. Could not find listed .Net services on my laptop,
  3. Deleting DATA files did not fixed the issue either,
  4. VS restart and reloading the solution.

I'm not sure if it was points 3 and 4 together that actually did the trick, but I'm putting it out there - just in case it actually is the procedure that will work for others, which is to try option 4.

I need to also note that this issue started after there was a momentary connection dropout. I need to work with WIFI instead LAN due to necessity to be roam-able, and every time I undock the laptop all my connections in SSMS are lost (and with them all the temp tables etc).

Upvotes: 0

datalifenyc
datalifenyc

Reputation: 2248

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

Upvotes: 3

KyleMit
KyleMit

Reputation: 29919

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:

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.
    Net.Pipe Listener Adapter - Services

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.
    Run RDLC from Solution Explorer

Upvotes: 4

SQLnbe
SQLnbe

Reputation: 868

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.

Upvotes: 19

Related Questions