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