The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I watched your video on "Configure Kerberos for Power BI reports in Reporting Services." I configured SPN's, ADUC object delegations & modified config file to RSWindowNegotiate and all worked fine. Now security team came back to me and stated a security scan has identified the 2019 SSRS window service account is using weak RC4-HMACEncryption. NOTE: We are running SSRS 2019 and use a user account and password to run the SSRS windows service (MSSQLSvc). My question is there a way to disable RC4-HMACEncryption on just this one SSRS service account without breaking the functionality of SSRS 2019 that I just configured per your article? I am concerned it may break something. Thanks.
This is an Active Directory setting. PBIRS does not really care as long as you have a valid Kerberos ticket. You just need to make sure that the service account has the property enabled to say that it supports the higher levels of encryption (so if you can I would suggest going up to AES256).
You can break things if you configure this wrong, but as long as you have both the AD policy set that requires AES256 for Kerberos and have the setting enabled on the service account to say that it supports AES256 it should just work.
If you can try and test this on a non-prod environment first. At my old company the IT team just enabled the group policy setting on the server without turning on the setting on the service account and this broke us for a few days until I figured out what had happened. Then we just had to tick the option on the service account and everything started working again.
Thanks for the great suggestion. To clarify further, where exactly in the Active Directory object are you suggesting I tick the option that supports higher levels of encryption for everthing to work? I have included a print screen of my Active directory object user account we are using a a service account to run the SSRS service. These setting on the ADUC SSRS object Microsoft recommended in order to get SSRS browser to work properly.