SSRS Web Service URL Provides an Error (500)

Question

When I try to access the SSRS Web Service URL (e.g http://SERVERNAME:1234/ReportServer/), it provides me with an Error 500. However, the Web Portal URL (http://SERVERNAME:1234/Reports/) works just fine. It even provides me with the UI for the SQL Server Reporting Services.

So far I've tried re-installing the SSRS, changing the ports, accounts and the database, all without any luck (the Reporting Services service is running). I am genuinely out of ideas and Microsoft's documentation is terrible regarding this particular issue as it suggested attempting to modify the NETWORK SERVICE account permissions, which can be done after adding one of the Windows features (which, I may add, can be done only on the Enterprise version of WIndows 10).

Has anyone had this issue or managed to find a workaround?

Use the "Reporting Services Configuration Manager" tool to verify and/or configure the URL for the web service. — Wolfgang Kais, Feb 10 '19 at 15:30

score 3 · Accepted Answer · answered Feb 10 '19 at 15:29

The instance of SSRS has two web applications, which are pretty independent. Normally they have such URLs:

In your case, seems first one configured and work correctly and the second one failing. The reason of a failure can be found in log files that are in stored in a SSRS instance folder, for instance:

D:\SQLData\MSRS13.MSSQLSERVER\Reporting Services\LogFiles

This path can be different, depends what was chosen during the initial installation as the instance directory. It can be found by opening a task manager and discovering a file location of ReportingServicesService.exe:

Then, in the LogFiles directory open the most recent log file and check for messages with a category ERROR, like:

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RequestTypeList'. ---> System.Data.SqlClient.SqlException: Invalid object name 'dbo.FactHistoricTrend'.
Could not use view or function 'dbo.FactFlatSSRS_Trend' because of binding errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)
   --- End of inner exception stack trace ---;

In this way, you will know what is the reason of Error 500 of your ReportServer web service

score 2 · Answer 2 · answered Feb 10 '19 at 23:14

While I will mark Alexander's post as the answer because it was a good indication on how to debug the issue, I will post that the actual issue were permissions - I had to provide the NETWORK SERVICE account with rwx permissions for the SSRS root folder (in my case, it was the E:\Program Files\Microsoft SQL Server Reporting Services; Properties -> Security -> Edit...).

Tim Cooke · Answer 3 · 2022-11-09T14:53:42.150

0

A few years late, but still an issue with SSRS 2019.

Following on from TheDoomDestroyer's comment, giving the service account used for the SSRS service, in our case a domain account, full control on the SSRS folder worked. Restarted the SSRS service and then was able to get the ReportServer URL.

Another annoying MS omission when configuring the service that it doesn't do that itself.

edited Nov 09 '22 at 14:53

answered Nov 09 '22 at 14:53

Tim Cooke

1
1

score 0 · Answer 4 · answered Jul 07 '23 at 12:29

0

in my case, it was disk issue, there was no space on left on the drive.

answered Jul 07 '23 at 12:29

Sam Salim

2,145
22
18

alexyon · Answer 5 · 2023-07-09T20:44:52.083

-1

You made my day, worked after I did this (nothing else): "giving the service account used for the SSRS service, in our case a domain account, full control on the SSRS folder"

edited Jul 09 '23 at 20:44

answered Jul 04 '23 at 17:21

alexyon

1
1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 08 '23 at 16:58

SSRS Web Service URL Provides an Error (500)

5 Answers5

Linked