Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenchee
Starting Member
49 Posts |
 Posted - 2010-08-01 : 20:05:49
|
| Hi, I'm trying to get a non-admin domain user to have access as a system administrator in Reports Manager for sql 2008 r2 but I keep on getting User '<domain/user>' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. This user is accessing this from his XP SP3 pc and the Reporting Services is on a server. However, if I were to make this user a local admin on the server, that user will be able to access it without an issue. My issue is that I do not want to give local admin rights to this user but still wants him to access ReportsManager as a system administrator. Can someone please help? ThanksKen |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2010-08-01 : 20:42:33
|
| Have you given the user access within report manager under the two required sections? Also you may need to provide access within a firewall? If these could be issues, if you provide your email address I can send you a document on how to do these tasks. I have normally users accessing report manager over a domain without them having any special access. |
 |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2010-08-01 : 20:50:30
|
| Hi Steve, Thanks. I have given the user access to System Administrator under the security tab on ReportsManager. Firewall is disabled on both pc and server. I have PM you my email address. ThanksKen |
|
|
|
kenchee
Starting Member
49 Posts |
Posted - 2010-08-01 : 23:11:05
|
| I found my problem. Thanks to Steve for pointing me to the right direction. I have forgotten to add the user role found under the "Folder Security" Tab on the home page. I've only added the system roles of "system administrator" hence my problem. |
|
|
|
prasad0482
Starting Member
12 Posts |
Posted - 2010-10-11 : 02:22:13
|
quote:
Originally posted by kenchee
I found my problem. Thanks to Steve for pointing me to the right direction. I have forgotten to add the user role found under the "Folder Security" Tab on the home page. I've only added the system roles of "system administrator" hence my problem.
Hi Kenchee,I am encountered same problem but i cant get solutions can you reply me how to solve this issue, report manager cannot access non admin's.plz send me screen shots.prasad0482@gmail.comThanksPrasad. |
|
|
|
prasad0482
Starting Member
12 Posts |
Posted - 2010-10-11 : 02:25:36
|
quote:
Originally posted by harlingtonthewizard
Have you given the user access within report manager under the two required sections? Also you may need to provide access within a firewall? If these could be issues, if you provide your email address I can send you a document on how to do these tasks. I have normally users accessing report manager over a domain without them having any special access.
HI Harlingtonthewizard,I am encountering problem with report manager, non admin cannot access report manager in their own PC's. if they can it showing empty I mean no deploying reports cannot display in report manager. how can i solve plz bring me out from this problem, if have any stuff regarding this plz mail me.prasad0482@gmail.comThanks in Advance.Prasad.Bonthu |
|
|
|
jdbwfvp
Starting Member
1 Post |
Posted - 2010-11-01 : 13:38:16
|
| I have the same problem. Can someone send me a copy of the document Steve references above?Thanksjames.d.barnes@wellsfargo.com |
|
|
|
|
|
|
|
|
non admin users cannot access Reports Manager