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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,420 questions
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.
2,988 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,850 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bruce (SqlWork.com) 70,686 Reputation points
    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 40,356 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.