Creation and Configuration of "Reports" Domain User account to access SSRS Reports

Question

We want to create a generic "Reports" domain user account to access the various SSRS reports.

We know we want read/execute privileges within SQL Server with that domain user account.

How should that domain user "Reports" account be created, and with what domain privilege's are necessary for it ?

Is there a white paper on how to set this up ?

Thank you

Answer 1

Hi @vsslasd
If you want to create a new domain user, you can run Server Manager->Tools->Active Directory Users and Computers.
For configuring SSRS account, you can refer to this link: configure-the-report-server-service-account-ssrs-configuration-manager.
When granting permissions to a user, you need to assign the user a system role and an item role. For more details, you can refer to this link: grant-user-access-to-a-report-server.
If you want to create a custom role, you can use SSMS to connect to the Reporting Service, create a new role and customize the permissions granted to the role. You can see this link: role-definitions-create-delete-or-modify.
Best regards,
Aniya