Remove Windows Authentication from PowerBI Report Server

[hellodfkh]

Hello,

We have implemented a PowerBI Report Server on on premises infrastructure. But whensoever any user on the VM tries to access the report , they are prompted for Windows Credentials. We want to let go of Windows Authentication.

We have tried implementing custom authentication according to the official sample, but we get shown the error of that the applicaation cannot connect to SQL instance. 

Any turnarounds?

Much Appreciated!

[Anonymous · Accepted solution]

Hi @hellodfkh ,

It's crucial to ensure that your custom authentication method is correctly set up and that all necessary services, including SQL Server, are properly configured to recognize and work with this custom authentication.

More details:Configure custom or forms authentication on the report server - SQL Server Reporting Services (SSRS)...

Configure the web portal to pass custom authentication cookies - SQL Server Reporting Services (SSRS...

Ensure that SQL Server is configured to accept the type of authentication you're implementing. If you're moving away from Windows Authentication, make sure SQL Server is set up to accept SQL Server Authentication or the specific custom authentication you're using.

Change server authentication mode - SQL Server | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

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

[hellodfkh]

Hi @Anonymous , I was able to implement custom authentication where we are able to view reports without a login. But now when an external user is trying to access the report URL, the PowerBI interface loads but shows a 404 request.

I though have not done anything yet with the connection to my SQL database server. Is there any insight you could give me?

Really appreciate your help.

[GilbertQ]

Hi @hellodfkh 

As far as I am aware, people do need to authenticate in order to view the reports. I would chat with your network admin to enable the single sign on on the server where the reports are hosted.