Login username and password prompt for Power BI report web portal URL and SSMS Reporting Services

[nle]

Hi Team,

Issue: Username and Password prompt for Power BI report webportal URL

Issue: Using SSMS connect to Reporting Services URL endpoint Windows Authetication - errors.

I installed Power BI Report Server on-premise build 15.0.1105.230 and SQL Server 2019 on the same VM.

1. Authentication type within Report Server config.
<AuthenticationTypes>
<RSWindowsNegotiate/>
<RSWindowsNTLM/>
</AuthenticationTypes>

2. SPNs for the report server service account for both the FQDN and NetBIOS using a virtual URL of RSSBX
Setspn -a HTTP/RSSBX.co.com DOMAIN\RSService
Setspn -a HTTP/RSSBX DOMAIN\RSService

3. SPNs for the SQL server service account for a instance name
setspn -s MSSQLSvc/myhost.co.com DOMAIN\SQLServiceAccount
setspn -s MSSQLSvc/myhost.co.com:instancename DOMAIN\SQLServiceAccount

setspn -s MSSQLSvc/myhost:port DOMAIN\SQLServiceAccount
setspn -s MSSQLSvc/myhost:instancename DOMAIN\SQLServiceAccount

I've verified that the SPNs are setup properly.

When I access the web portal from the Power BI Report Server VM itself or from a workstation using IE, Edge or Chrome browsers, it prompt for username/password.

I use SSMS to connect to the Reporting Services with Windows Authentication, I get this error. I worked with Basic Authentication.

Really appreciate any help!

[nle · Accepted solution]

Hi,

I was able to fixed the authentication by converting the DNS Alias to to A-Name then Disable LoopBackCheck with PowerShell

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword

It doesn't prompt for usernane and password.

Thanks everyone!

[AlexSam]

Hi nle,

Because I currently have the same issue, can you probably provide more information on how you managed to resolve this. Some questions I have:

1) Do you use https:// for your Web Portal/Web Service URLs ?

2) When you say convert the DNS Alias, which DNS allias you mean? Have you configured the Web Portal/Web service URLs to use host headers?

3) You solved the issue when accessing the Web Portal from a workstation as well or only from inside the PowerBI server?

Thanks in advance

[laridae]

try adding the spns with the port number as well. Ours needed it to work. eg

Setspn -s HTTP/RSSBX.co.com:80 DOMAIN\RSService
Setspn -s HTTP/RSSBX:80 DOMAIN\RSService

[nle]

Hi Laridae,

It's still prompting for username/password.

Thanks,

nle

[HashamNiaz]

Hi @nle !

If this is a fresh PBI Report Server install, you might need to open IE / Edge on the machine where you installed RS. Open the browser using [Run as adminstrator] option

The Report Manager URL will be open this time

You need to add, domain user account [Site Settings] and also add role [Site Administrator] to your account
You also need to assign folder permission to your domain account
After its done, restart the PBI Report Service
Verify accessing PBI Report Manager URL from client machine
Hopefully this will work.

Regards,

Hasham

[nle]

Thanks Hasham, what I'm trying to do is to have the Power BI Web Portal to use Windows integrated security not prompt for username/password. 

<AuthenticationTypes>
<RSWindowsNegotiate/>
<RSWindowsNTLM/>
</AuthenticationTypes>

Regards,

nle