topic Re: How Connect User from One server to another server for viewing Report in Report Server

How Connect User from One server to another server for viewing Report

Prathamesh_29 — Tue, 03 Dec 2024 07:05:56 GMT

As In our work place we have 2 server
as in one server has Bi reporting service and the other server has active directory where the groups and users are
So intially want to connect the other server to first server by the same domain name as it replicate the active directory in first domain
so other server people where they are added in active directory can see the report using there credentials
is it possible
Thanks in Advance

Re: How Connect User from One server to another server for viewing Report

ChrisMuthmann — Mon, 02 Dec 2024 12:22:09 GMT

I don't know, if I understood your question quite well.

The both servers have to be in the same domain or in trusted domains. BTW I believe this seems to be better asked in a windows administration community.
Kind regards,
Christoph

Re: How Connect User from One server to another server for viewing Report

Prathamesh_29 — Mon, 02 Dec 2024 13:00:11 GMT

If They both use same domain would the second server people can login using the same credentials as they used for first server
and will user able to see the power bi reports server reports

Re: How Connect User from One server to another server for viewing Report

Anonymous — Tue, 03 Dec 2024 01:20:54 GMT

Thank you ChrisMuthmann

Hi, Prathamesh_29

Of course, you can access your reports from the Power BI Report server in another example. All you need to do is set it to scale out:

Configure a Native mode report server scale-out deployment - SQL Server Reporting Services (SSRS) | Microsoft Learn

If you have any questions during the setup process, please feel free to ask them on the forum.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How Connect User from One server to another server for viewing Report

Prathamesh_29 — Tue, 03 Dec 2024 05:26:02 GMT

Hey
Jianpeng Li Thanks For ur Reply
But I dont have the reporting Service in second server its in first server the database is too in first server
only the viewer are in second server where they added by active directory
as i saw solutions on this its says join 2 server by same domain so they can see by inputing there credentials
https://www.youtube.com/watch?v=8aR_0Fp55mg&list=LL&index=9 - Joing by same domain
https://www.youtube.com/watch?v=vCH8Fa3OpQ0&list=LL&index=2 -- and do i need to configure kerberos

Re: How Connect User from One server to another server for viewing Report

ChrisMuthmann — Tue, 03 Dec 2024 08:30:15 GMT

You are on the right way. You don't need kerberos if server and database are on the same machine. You only need kerberos with a double-hop.

Re: How Connect User from One server to another server for viewing Report

Prathamesh_29 — Tue, 03 Dec 2024 12:01:56 GMT

Thanks ChrisMuthmann
For Clarification
Actually the company is not taking Risk of joining the server by thier same domain
they told me to carry out the function in other 2 pc with 2 server and where this situation is there of pbirs and active directory just help out if i got stuck some where