In this case, the error can be resolved in one of two ways.
- Enable AES 128-bit and/or AES 256-bit encryption for the SQL Reporting Services service account
- Configure the Network security: Configure encryption types allowed for Kerberos policy setting on the reporting point server to include the RC4_HMAC_MD5 encryption type
Steps to configure the policy setting Network security: Configure encryption types allowed for Kerberos
Method 1 – Local Security Policy
- On the affected server, open an elevated command prompt
- Type SECPOL and hit Enter
- In the Local Security Policy management console, expand Local Policies and click on Security Options
- Scroll down in the left-hand pane until you find the setting Network security: Configure encryption types allowed for Kerberos
- Right-click this setting and select Properties
- In the Local Security Settings tab, check the box next to RC4_HMAC_MD5 , AES128_HMAC_SHA1 , AES256_HMAC_SHA1 , and Future encryption types
- Click OK
Method 2 – Group Policy Object (GPO)
- Open the Group Policy Management console and edit a new or existing GPO
- In the Group Policy Management Editor , expand Computer Configuration\Policies\Windows Settings\Security Settings\Local Policies\Security Options
- Right-click on Network security: Configure encryption types allowed for Kerberos and click Properties
- On the Security Policy Setting tab, check the box to Define these policy settings
- Check the box next to RC4_HMAC_MD5 , AES128_HMAC_SHA1 , AES256_HMAC_SHA1 , and Future encryption types
- Click OK
If this is for the specific service account, for example, an SQL Service account.
Steps to enable AES encryption for the SQL Reporting Services service account
- Open Active Directory Users and Computers
- Browse to the user account used by SQL Reporting Services on the affected server
- Right-click the user account and select Properties
- Click on the Account tab
- Under Account options , check the box next to one or both of the following:
- This account supports Kerberos AES 128 bit encryption
- This account supports Kerberos AES 256 bit encryption
- Click OK