user2596180
user2596180

Reputation: 51

SSRS and AD Groups

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

Answers (2)

Minkus
Minkus

Reputation: 462

Had a similar issue where SQL Server Reporting Services was failing to recognise recently added permissions on a group. Try the following:

  • Clear the Kerberos cache on the client machine by running 'klist purge'
  • Then completely restart the user's browser (don't just close the tab)

Fixed the problem here.

Upvotes: 0

suff trek
suff trek

Reputation: 39767

You have to assign that AD group an SSRS Role in SSRS Manager

enter image description here

Depending on permission you want to give it.

Upvotes: 5

Related Questions