Forum Discussion

Abdelmajid's avatar
Abdelmajid
Icon for Helper I rankHelper I
5 years ago

Unable to Access PBIRS Dev after restore from Prod

Hello,   We have performed a restore on PBIRS Dev environment using Prod Backup. I can see that the conetnt is there when I query it, but getting this error message when trying to access the PBIRS ...
Unable to Access PBIRS Dev after restore from Prod
Abdelmajid's avatar
Abdelmajid
Icon for Helper I rankHelper I
5 years ago

Thank you Farhan, there was an issue with access permissions and also the Encryption Keys had to be resotored from Prod as well.

I am able to access PBIRS Dev and see all reports, but I am not sure why I am seeing the Prod nodes added to the scale-out-deployment as shown below.

 

Trying to remove the Prod nodes results in the beow error:

Appreciate if any help.

FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
5 years ago

There is a table in reporting server database "dbo.keys" which have entries of deployment servers

 

Removing from that table will remove entries from "Scale-out" deployment. 

But you should be careful on how you would delete such entry.

Try backup this table and then try to remove the wrong entries and restart the reporting server  services 

Then this error will probably be gone.