Active Directory Groups and adding and utilizing security

we have sql server reporting , report manager. when run following script, tells me in "acs" domain.

select	default_domain()

when attempt add , utilize "acs\" active directory groups , add them security report manager portal, not seem function correctly.

so i've attempted do...

1. identify via microsoft outlook active directory group business user has been defined to
2. remote desktop connect our report manager server
3. within control panel, edit local users , groups , add new user...the active directory group
4. then within sql server management studio, add active directory group new login using search , groups
5. add database security accordingly newly added active directory group
6. add report manager portal security newly created active directory group

when 1 of business users defined "acs\" active directory group attempts access folder have defined security for, cannot seem it. interesting part of though select domain indicates "acs", can add "corp\" active directory groups , seem work fine.

can clarify of me , try , shed light might going on here? know lot of site specific...but i'm hoping maybe has experienced these same issues or can shed light on procedure i'm invoking add these active directory groups.

thanks review , hopeful reply.

hi itbobbyp,

according description, when add “acs\” active directory group report manager site settings , item-level role, user can’t access folder, right?

in scenario, since server within “acs” domain, after granting user system-level role , item-level role, user able access corresponding report server item. please check if have set item-level role specific folder or parent folder. can check reporting services error log (default location: %programfiles%\microsoft sql server\<sql server instance>\reporting services\logfiles) around time user can’t access folder find root cause.

in reporting services, if want access reporting services other domain, should apply domain trust or extranet deployment. considered “same” domain ssrs users trusted domain can access reporting services. , when outer domain user access current domain, need provide credential. can check if have configured domain trust or extranet deployment. see:

trust types
planning extranet or internet deployment

if have question, please feel free ask.

best regards,
qiuyun yu

---

qiuyun yu
technet community support

SQL Server  >  SQL Server Reporting Services, Power View