topic Re: Login username and password prompt for Power BI report web portal URL and SSMS Reporting Services in Report Server

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

nle — Wed, 26 May 2021 16:43:44 GMT

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!

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

HashamNiaz — Thu, 27 May 2021 20:29:51 GMT

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

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

Anonymous — Fri, 28 May 2021 12:31:32 GMT

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

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

nle — Wed, 02 Jun 2021 15:50:53 GMT

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.

Regards,

nle

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

nle — Wed, 02 Jun 2021 15:52:12 GMT

Hi Laridae,

It's still prompting for username/password.

Thanks,

nle

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

nle — Thu, 17 Jun 2021 00:28:56 GMT

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!

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

AlexSam — Mon, 29 Nov 2021 11:23:02 GMT

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