Forum Discussion
Powerbi reportserver is not show connection string and credential after restore
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 wi...
Did you restored the encryption keys as well ?
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
Did you restored the encryption keys as well ?
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).