Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Prathamesh_29
Frequent Visitor

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

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 

1 ACCEPTED SOLUTION
ChrisMuthmann
Resolver II
Resolver II

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.

View solution in original post

6 REPLIES 6
Prathamesh_29
Frequent Visitor

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 

ChrisMuthmann
Resolver II
Resolver II

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.

Prathamesh_29
Frequent Visitor

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

ChrisMuthmann
Resolver II
Resolver II

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

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 

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) | ...

vjianpengmsft_0-1733188624038.png

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.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.