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 |
|
jasonwisdom
Starting Member
1 Post |
 Posted - 2010-08-06 : 14:56:05
|
| Hi all,We are installing SQL Server 2008 r2 onto a server, and this installation includes Reporting Services.SSRS works, I can deploy reports, use Report Manager, Report Builder, etc., all using my admin privs.The problem is when NON-ADMIN users connect to \\server\reports. They get the following error: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 error is resolved by giving the DOMAIN\user account local admin privs on the server.Granting admin privs is not a solution. We have accountants and other non-technical people that will use Report Manager and Report Builder. We can't just give every person admin privs on the production SQL server.I have done a lot of research on the web... I see a results involving earlier versions of SQL Server and Report Manager, but this is 2008 r2 - different webserver, etc.How can I resolve this issue? |
|
|
kenchee
Starting Member
49 Posts |
Posted - 2010-08-11 : 21:58:17
|
| Hi, I had the same issue before. To resolve this, you will need to go into server\ReportsManager, under "Folder Settings", click on "New Role Assignments" then assign the roles needed for your non-admin user. Hope this helps |
 |
|
|
|
|
|
|
|
User Permission errors - 2008 r2 Report Manager