SQLTeam.com | Weblogs | Forums

I need to be able to search LDAP/Active Directory with User!UserID for their memberof to see if they belong to a group in a report in SSRS 2016


We have two domains and I need to be able to have a query in SSRS 2016 on domain A search to see if a user belongs to a group in domain B. Both domains can talk to each other. We cannot use a linked server or store any of domain B's info in domain A. We would be able to store the data while the user session is alive in domain A. Please help!

DomainA if User!UserID belongs to groupAdomainB grant access to reports A,B,D but not report C.

DomainA if User!UserId belongs to groupBdomainB grant access to report C but not reports A,B,D.

Thank you in advance!