We are installing SQL Server 2008 r2 onto a server, and this installation includes
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?
View Complete Post