Powerbi reportserver is not show connection string and credential after restore

[peacherry]

Hello ,

I use Powerbi report server on premise May 2019 version (window server 2012) on Production include 1 database server (sqlserver 2014 std) and 2 powerbi servers.
I prepare the new cluster with backup restore reportserver and reportservertempdb database (sqlserver 2014 std) (backup from production) and config powerbi (May 2019 )to connect reportserver and reportservertempdb on new environment but when i connect new Powerbi web https://<PBIRS-servername>/reports/ and go to datasource . I found that Connection is not show connection string and credential are null even though production have connection string and credentials

Have you found this issue or some case that's similar to my issue ? would you please help?

thank you,
Peach

[FarhanAhmed · Accepted solution]

Did you restored the encryption keys as well ?

[peacherry · Accepted solution]

my issued was solved . I do the step as below 

- backup reportserver and reportservertempdb from production cluster then restore on the new cluster

- backup encryption key from production and restore on the new cluster

-  Delete unuse hostname 

USE ReportServer;

GO

begin tran

DELETE FROM dbo.Keys

WHERE Machinename in ('....')

GO

commit

- Restart PowerBI service 

- check Connection string and it's show as the same as production

thank you,

Peach

[FarhanAhmed · Accepted solution]

Did you restored the encryption keys as well ?

[peacherry]

Im trying but question is when I restore encription key from production ,in the scale-out will show server same as production. Can I delete server (production server) from scale-out on new server (that I just restore).