Oleg Oleg - 1 month ago 14
SQL Question

How to add user to modify SSRS report with different domain name?

I need to add user that would be able to modify SSRS reports. But the thing is that user have different domain name.
So I get an error saying that user or group name is not recognized.
enter image description here

In order to add user I am going to Site Setting - New Role Assignment and adding new one
enter image description here
What am I missing?

Answer

You are assigning permissions at wrong place. you are giving extra privilege by adding user under site setting. That user can do anything in the the report manager.

It should provide permission at Report or Folder Level

Go To properties of report > Security > Provide Report builder access (if user is supposed to modify in place in report manager)

http://bhushan.extreme-advice.com/user-roles-and-permissions-in-ssrs/

Also, as per your comment, check if the mentioned domain user can/supposed to connect to your report manger.

Comments