Resource-Based Kerberos Constrained Delegation trouble
Hi, We use Power BI Report Server 1.10.7737.32652 in conjunction with SQL 2019. Products are deployed on different servers (Windows Server 2016 and Wibdows Server 2019). A domain service account is used to start the PowerBIReportServer service, and the gMSA domain account is used to start SQL services. Resource-based Kerberos Constrained Delegation (RBKCD) is configured between these accounts. In the rsreportserver.config file, the authentication type is set to RSWindowsKerberos. Users with Windows authentication have been created on the SQL server to access the required database. When we try to open a report in an Internet browser (DirectQuery connection type), we get the error "We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.". In the logs of the SQL server we see attempts to connect as an anonymous user (Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'). Perhaps someone faced a similar problem?
