Extracting Linked Server details from Data Sources of SSRS Paginated Reports

  • hi Friends,

    Here is the example Scenario:

    An SSRS Paginated Report has 2 data sources.

    Data Source 1 (Shared Data source which is Sql Server based)

    Data Source 2 (Expression based custom data source)

    The expression used in the Data Source 2 may also refer to some linked server.


    Extract the data sources details like the connection string, Username (that is used in the connection string), any linked servers involved details

    Can anyone please help or provide a query which extracts these details from the Sql Server Audit tables ?

  • If you are hoping to get this information by querying the ReportServer database, I think you are going to be disappointed. The connection string information is encrypted, with no supported method of decryption available, as far as I know.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply