Required help to fix encryption key related issue on PowerBI report server

[patilamol93]

Hi folks,

We had 2 powerBI report server configured to connect with same database and recently there was a request to change service account and database credentials on those servers. Able to change the account but it looks like I have used same encryption key to restore it on both servers and currently only 1 server is working at a time another throws an error "service unavailable" scale out & encryption key related error.

Tried deleting the encryption key on server2 but it deleted all the connections strings and content from server1 as well , so not able to figure how to reconfigure both servers to work together ,kindly suggest/

[Anonymous · Accepted solution]

Hi @patilamol93 ,

Since you’ve restored the same encryption key on both servers, it’s causing conflicts.

To resolve this:
      1.On one of the servers (let’s call it Server1), back up the encryption key.
      2.On the other server (Server2), delete the existing encryption key.
      3.Restore the backup key from Server1 onto Server2.
This should ensure that both servers have unique encryption keys while still using the same report server database.

Below is the detail information about this:

SCCM Power BI Report Server Integration | System Center Dudes

Configure a report server database connection (Report Server Configuration Manager) - SQL Server Rep...

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.