topic Re: User login into Report Server On premises in Report Server

User login into Report Server On premises

panchag — Mon, 04 Feb 2019 21:15:40 GMT

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.

Re: User login into Report Server On premises

panchag — Tue, 05 Feb 2019 16:33:02 GMT

Well Guys, Any Ideas /Sugesstions?

Re: User login into Report Server On premises

adrez86 — Tue, 05 Feb 2019 19:38:30 GMT

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

Re: User login into Report Server On premises

Anonymous — Tue, 25 Aug 2020 17:02:07 GMT

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