topic Re: Powerbi reportserver is not show connection string and credential after restore in Report Server

Powerbi reportserver is not show connection string and credential after restore

Anonymous — Tue, 12 Oct 2021 03:20:55 GMT

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

Re: Powerbi reportserver is not show connection string and credential after restore

FarhanAhmed — Tue, 12 Oct 2021 08:28:21 GMT

Did you restored the encryption keys as well ?

Re: Powerbi reportserver is not show connection string and credential after restore

Anonymous — Tue, 12 Oct 2021 08:38:17 GMT

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).

Re: Powerbi reportserver is not show connection string and credential after restore

Anonymous — Tue, 12 Oct 2021 09:28:20 GMT

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;

begin tran

DELETE FROM dbo.Keys

WHERE Machinename in ('....')

commit

- Restart PowerBI service

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

thank you,

Peach