Home / server / Questions / 454832
In Process
Aleksey Shubin
Asked: 2012-12-05 00:09:48 +0800 CST

SSRS 2008 R2 domain user assigned for role but cannot access

  • 772

I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator).

First I get the error "Unsufficient permissions". Then I started Report Manager at the server (http://localhost/Reports/) and under Site Settings / Security added my domain user to both System Administrator and System Users roles, restarted the service, but still got the same error.

Then I created a folder in Report Manager and added domain user to all available roles for that (Browser, Publisher, etc.). After that it doesn't show that error in BIS but instead shows the login dialog (though I already logged as domain user in Windows). I enter login and password but it just asking it again and doing nothing. Tried to enter administrator login details but it also just shown again.

Could you advice me how to enable access to the service or at least to some folder for non-administrator domain user?

ssrs

1 Answers

  1. Try changing the following setting in the RSeportServer.config file: AuthenticationType to RSWindowsNTLM

    see more info here: http://msdn.microsoft.com/en-us/library/cc281253.aspx

    • 0