Forum Discussion

av_mikhailov's avatar
av_mikhailov
New Member
8 years ago

DirectQuery Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Hi all,   I have Power BI report with DirectQuery to MS SQL 2016 database. Report works locally on Power BI Server, and works remotely in Chrome in my admin credentials   But report don't work on...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

That guide only explains how to set up Kerberos with SSAS as a datasrouce, rather than an SQL Server.

 

Has anyone managed to resolve their Kerberos double hop issue? We're still getting the error that than original poster specified.

 

Our setup:

Report Server: RS1 running under a domain account DOMAIN\RSService

Database Server holding the data for the Report Server reports: DB1 running SQL Server under a domain account DOMAIN\DBService

 

SPNs set for RS1: 

  • http/RS1 DOMAIN\RSService
  • http/RS1.domain.com DOMAIN\RSService

SPNs set for DB1:

  • MSSQLSvc/DB1 DOMAIN\DBService
  • MSSQLSvc/DB1.domain.com DOMAIN\DBService
  • MSSQLSvc/DB1:1433 DOMAIN\DBService
  • MSSQLSvc/DB1.domain.com:1433 DOMAIN\DBService

Constrained delegation has been set up on RS1, and it allows authentication to DB1 for the above SPNs.

ReportServer config has also got <RSWindowsNegotiate/> set as a <AuthenticationType>.

We manage to query the reports successfully via DirectQuery in Google Chrome, not as much success using Internet Explorer (v11).

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago