How can DomainA user acces DomainB SSRS?

pnany 20 Reputation points
2025-01-20T16:27:32.8966667+00:00

Hi all,

I got a problem with SSRS. I run an SQL server on DomainA but I would like to let some DomainB users read the reports. Is it possible? If it is, the how can i do it?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
Windows for business | Windows Client for IT Pros | Directory services | Active Directory
SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator
    2025-01-20T17:11:04.9133333+00:00

    First your as administrator would need to setup a trust relationship between domain an and b. This would allow domain a to trust a domain b authentication.

    https://learn.microsoft.com/en-us/entra/identity/domain-services/concepts-forest-trust

    once this is done you can enable domain b users and groups.


1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,491 Reputation points
    2025-01-21T01:36:27.7666667+00:00

    Hi @pnany

    Make sure the two domains will need to have trust between each other, so that you can authenticate still.

    You may kindly check Trust between two domains

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.