Reputation: 51
I had a request come through asking me to create an AD Security group that could be used in SSRS for users to get reports. There are currently other AD groups that work but the one I have created does not allow users to connect. Creating AD groups isn't real difficult and I know I have it set up correctly. Does anyone have any input as to why the group is not working? I have no knowledge of SSRS or SQL in general so any help would be appreciated.
Upvotes: 5
Views: 7652
Reputation: 462
Had a similar issue where SQL Server Reporting Services was failing to recognise recently added permissions on a group. Try the following:
Fixed the problem here.
Upvotes: 0
Reputation: 39767
You have to assign that AD group an SSRS Role in SSRS Manager
Depending on permission you want to give it.
Upvotes: 5