May 16, 2013 at 7:01 am
Hi,
Can anyone tell me what permissions I need to assign to a user to allow them to log into Reporting Services via management studio ? They need to be able to change reporting services server settings and manage jobs.
In tests the only way I've been able to do this so far is by assigning local admin rights (tried a number of ways) - surely there must be a more restrictive way of doing this ?
Any help much appreciated!
Cheers
Vultar
May 17, 2013 at 12:58 am
It looks like the user needs to be assigned to the System Administrator role, see http://msdn.microsoft.com/en-us/library/ms159797.aspx.
May 17, 2013 at 7:29 am
Thanks for your response!
Granting these permissions was one of the 1st things I tried - tried again to double check and it still didn't work.
I've made some progress since my original post.. if I add my account to the 'Distributed COM Users' local group lets me connect via SSMS. Here's the link where I read this;
The question now is, why do we have to add users to this group and is there another way round it ? We've got other SSRS installations which we can connect to via SSMS without adding users to this group. Anyone know why ? I've checked group policies etc. Maybe something to do with the way SSRS has been installed ?
Cheers
Vultar
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply