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,370 questions
{count} votes

Accepted answer
  1. AniyaTang-MSFT 5,631 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 No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 29,196 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 No comments