Forum Discussion
Remove Windows Authentication from PowerBI Report Server
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!
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.
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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.
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
