topic Re: Power BI Report Server - Authentification with Basic Auth in Report Server

Power BI Report Server - Authentification with Basic Auth

mypbishell — Wed, 16 Mar 2022 18:38:43 GMT

Hello,

Version : PowerBI Report Server January 2022

Can NTLM and Basic Auth coexist ?

My organization is using the NTLM authentification.

However, I need to connect to my report also using the Basic Auth.

So I followed the following procedure

My config file of my report server look like :

I restarted my Report Server and tried to connect to my report url using postman.

When I used the NTLM Authentification, it worked (Request had a 200 status response).

But when I used the Basic Authentificationm it didn't worked (Request had a 401 status response) :

Similar to 403 Forbidden, but specifically for use when authentication is possible but has failed or not yet been provided. The response must include a WWW-Authenticate header field containing a challenge applicable to the requested resource.

This is why I ask if NTLM and Basic Auth can coexist.

What am I doing wrong ?

Have a nice day.

Thanks by advance.

Re: Power BI Report Server - Authentification with Basic Auth

d_gosbell — Wed, 16 Mar 2022 22:29:19 GMT

The documentation does state that NTLM and Basic should be able to coexist.

What sort of authentication is your report data source using? It does state in the documentation for Basic auth https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-ver15 that the "Windows Integrated" option will not work (this is the "As the user viewing the report" option in the data source settings)

Re: Power BI Report Server - Authentification with Basic Auth

v-luwang-msft — Mon, 21 Mar 2022 08:41:56 GMT

Hi mypbishell ,

In my opinion ,it should be able to coexist.

And request had a 401 status response,there may be two causes for this error.

The Password Manager Account may not have the correct permissions to access the Reporting Services Server (i.e. Content Creator rights on the SRS Reporting side).
In complex network environments Windows Integrated Security may fail to authorize the user (client) on the Reporting Services Server because the authorization request is transferred through Password Manager server with impersonated credentials. This case is known as a double-hop issue. A double-hop issue occurs when the SQL Database and the SQL Reporting Services are on two different servers.

and detail soultion ,refer:https://support.oneidentity.com/pt-br/kb/69693/report-server-error-the-request-failed-with-http-status-401-unauthorized

Similar case refer:

https://www.sqlservercentral.com/forums/topic/report-builder-2-0-with-basic-authentication-throws-error-on-preview-the-request-failed-with-http-status-401-unauthorized

https://stackoverflow.com/questions/19247645/the-request-failed-with-http-status-401-unauthorized-in-ssrs

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

Re: Power BI Report Server - Authentification with Basic Auth

v-luwang-msft — Wed, 30 Mar 2022 09:28:04 GMT

Hi mypbishell ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien