Migrate SSRS users from one server to another

Jayraj Parsa 1 Reputation point
2020-10-02T14:46:10.647+00:00

I have some reports on one server which i'm migrating to another server. I would like to migrate users tied to those reports and assign users to the designated reports. Is there a way to do his programatically or do we have to this manually?

Any help much appreciated

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,911 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-10-05T01:32:20.897+00:00

    Hi,

    Normally, you need to create the new user at the new Server. They are at the system level and won't be copied with SSRS server.

    You could follow this article, and there are scripts in it that is useful for this scene. Move SQL Reporting Services to Another Server

    Reagrds,
    Lukas


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.