Post reply

How to change shared datasource in Report Server SSRS using t-sql?

  • April 18, 2022 at 10:25 pm

    #4018253

     

    I need to change a shared datasource for more than a hundred reports from Report Server. (the step below on a snip)

    So for each report on a server I'd go to "Manage" --> "Datasource" and from there select datasource I need.

    Is any way I can do that using t-sql in ReportServer database?

    Attachments:
    You must be logged in to view attached files.

  • April 19, 2022 at 11:10 pm

    #4018855

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • April 19, 2022 at 11:13 pm

    #4018857

    I'd see if you can't do it with PowerShell.  Rob Sewell & Chrissy LeMaire may well have that in their dbatools library. I'd look at that first, or ask them on twitter if you can't find it. (But look first!)

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

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