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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
panchag
Regular Visitor

User login into Report Server On premises

I have setup  Report Server on my PC (WIN 10) with SQL Server Evaluation Version .

 

I was able to access  Report Server URL and also create sample .pbix and publish it to Report server. I want to share the content to the users so that users could login and explore.

 

I was able to add the users in site settings > Security who are in our AD group. 

 

I shared my URL : http://[IP address of PC:80/Reports/browse/

 

But users are not able to login. What is the process for users to log in into Report Server and  view the content.

3 REPLIES 3
roger_that
Regular Visitor

For those coming much after this question was asked,  my experience was that I needed to add the users (or groups) to SQL server security, so that requests could be checked for permissions to perform the operation requested.  Think:  user -> PBIRS -> SQL Server -> Active Directory.   If a user is not in SQL Server security, his/her request will not be passed on to AD for a check of permissions.  I created an AD group called PowerBI, and gave that group needed permissions in SQL server.  You can add groups for Publisher to AD, and add people to that group, and use that group membership within the PowerBI Report Server, to grant them the right to publish reports.

Roger

 

panchag
Regular Visitor

Well Guys, Any Ideas /Sugesstions?

Are the users that are trying to get to the reporting site connected to the same network that you are?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors