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...
tragonneau's avatar
tragonneau
Frequent Visitor
8 years ago

Hello, I have the same error when I use Chrome.

 

It works when I use IE.

I tried to import settings from IE but I still have the same error.

  • 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
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I am having the same problem with Direct Query of MS SQL Server in Azure.

       

      I am using SQL authentication. It works in Power BI desktop. After publishing, report shows the error (see below)

      I have also updated published dataset with credential using Basic method with SQL authentication credentials.

       

      I am not sure what have I missed here. Please help.

       

       

      Here are the details.

       

      Couldn't load the schema for the database model
      Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
      Please check the technical details for more information. If you contact support, please provide these details.
      Underlying Error: A connection could not be made to the data source with the Name of '07fcf078-7916-4e68-8852-95a5577a3137'.  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. The exception was raised by the IDbConnection interface.
      Activity ID: 0df9a08b-9ea2-4f87-86b6-0a9e35709d04
      Correlation ID: 3041412f-1eae-eb47-322b-e218a262a5e8
      Request ID: 6a152610-a197-807e-07fe-9469afcf8185
      Time: Wed Oct 24 2018 10:30:11 GMT-0700 (Pacific Daylight Time)
      Version: 13.0.7220.114
      Cluster URI: https://df-msit-scus-redirect.analysis.windows.net

       

      • Robinator's avatar
        Robinator
        Frequent Visitor
        7 years ago

        Dit you find a solution? 

         

        got myself the same issue:  Direct Query of MS SQL Server in Azure.