Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello!
We have 2 servers where Report Server is located:
We had the similar problem earlier, and it was resolved by several ways:
1) We changed the name in Report Server Configuration Manager (virtual service account and domain account). Did that now and it didn't help
2) Changed config files. On broken server, we removed the authentication type <RSWindowsKerberos/> in the rsreportserver.config file:
<AuthenticationTypes>.
<RSWindowsNTLM/>.
<RSWindowsKerberos/>.
</AuthenticationTypes>.
Saved the config, waited half a minute and then created a new plan. It worked last time and then it was possible to create scheduled refresh, etc.
Now we have tried both of the options, but nothing has changed.
Could anybody please tell where the problem lies or where ot start looking?
Thank you in advance!
This problem seems more related to the ReportServer database. If you have some reports that exist in DB. you can take a backup of it and back of the Encryption key from the Configuration Manager.
Then you need to restore this database with New Name, and then change the database of the Report Server using the Report Server Configuration manager and restore the encryption keys to sync the values.
Proud to be a Super User!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.