2

I've got SQL Server 2017 Developer installed on my workstation, and just installed SSRS 2017. I am able to navigate in the SSRS portal, and upload files of dummy data, and create KPIs. However, when click "+New", then "Dataset" or "Data Source", I get the message "Something went wrong. Please try again later." The only clue in a log file is in my RSPortal_yyyy_mm_dd......log file which shows the following:

OData exception occurred: Microsoft.SqlServer.ReportingServices2010.RSConnection2010+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'

I get the same error if trying to upload an .rdl file.

I did a "next/next/next" install of SSRS, keeping the defaults. The only unusual thing is that I am logged in with a machine account, not a user account. This machine account does show in the top right corner of the SSRS web portal, so that is passing through at least.

What could be happening here?

  • have you migrated your report server from older version to 2017? – Rajesh Ranjan Jul 14 '19 at 8:32
  • No, this was a fresh installation of SSRS 2017. – SomeGuy Jul 15 '19 at 14:21
  • It seems like you are using RS endpoint URL to connect report server. Go to Report Server Manager and check the URL. It should be like URL:servername/ReportServer – Rajesh Ranjan Jul 17 '19 at 2:34
0

I couldn't figure out the specific failure reason here, but found that if I switched to a domain account instead of "Virtual Service Account" or "Network Service" built in to Report Service Configuration Manager and then restarted the machine, things started working properly

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.