Find SSRS database and server name

Terry St Jean 81 Reputation points
2023-05-16T11:59:10.51+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,798 questions
Accepted answer
  1. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-05-17T02:25:08.7333333+00:00

    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:

    1

    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

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,741 Reputation points
    2023-05-17T05:13:54.0533333+00:00

    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).

    0 comments