Find SSRS database and server name

Question

With only a SSRS Reporting Server web service url, is it possible to determine the name of the Reporting database and the server the database resides on?

Answer 1

Hi @Terry St Jean

There seems to be no way to find the database name and server name of a report directly through the web service URL. But if your data source has been published, you can access the data source using the rs:Command=GetDataSourceContents parameter.

For example:

For information about SSRS URL access, you can refer to this document: https://learn.microsoft.com/en-us/sql/reporting-services/access-report-server-items-using-url-access?view=sql-server-ver16.

Best regards,

Aniya

Answer 2

With only a SSRS Reporting Server web service url, is it possible to determine the name of the Reporting database and the server the database resides on?

No, you have to lookup the configuration in the RSCM = "Reporting Service Configuration Manager".

E.g. the ReportServer database can be anywhere, for example when you have setup a SSRS farm (scale-out).