SQL 2008 Reporting Services - how do you add a user to Administrator Group?

noamco36
noamco36 used Ask the Experts™
on
Hello:
How do you add a user to the Administrator Group?
And, how to you see the list of existing users within the Administrator Group?

(See screen shot)

Thanks.
Administrator-Group.docx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jason YousefSr. BI  Developer
Commented:
Hi,
You just need to click on "New Role Assignment" and add whoever you need as a browser or content manager...etc..

check this KB http://technet.microsoft.com/en-us/library/ms156014%28v=sql.105%29.aspx

for multiple answers on all the SSRS permissions

Author

Commented:
If I open "New Role Assignment" it prompt me to ADD a new ROLE.
But How do you add a user to the EXISTING Administrator Group?
And, how to you see the list of existing users within the Administrator Group?
Jason YousefSr. BI  Developer
Commented:
Have you deleted the existing roles? http://msdn.microsoft.com/en-us/library/ms156293.aspx
look at the attached screen-shot..

that's where you need to add the users and give them admin or user permissions..
ssrs
new role assignment
http://msdn.microsoft.com/en-us/library/ms179929.aspx
BI Consultant
Most Valuable Expert 2011
Commented:
"If I open "New Role Assignment" it prompt me to ADD a new ROLE."

No it doesn't, it only looks that way.  The New Role Assignment page allows you to enter a user or group name (Active Directory) and link it up to a role.

"And, how to you see the list of existing users within the Administrator Group? "

The screenshot that you've included is displaying the list of users/groups and their rights (roles) on the report server.  What's weird though is that your built-in admins don't seem to have system administrator rights, only Browser and Content Manager.

To find out how the roles are defined (role definitions can be changed), use the Management Studio to connect to your report server (in Object Explorer: Connect > Reporting Services).  If you then open up the Security node you should see the roles and be able to get their properties.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial