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 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
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
3 Replies
FarhanAhmedCommunity Champion
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