question

KerryOu-8610 avatar image
0 Votes"
KerryOu-8610 asked Willsonyuan-msft commented

SSRS move to another new server , reports were missing the data source.

Hi , I restore [ReportServer] and [ReportServerTempDB] from old SQL server.
All reports are there, but can't be opened, need to input data source user name and password.
Am I missing something? I don't want to set data source one by one. Please help.
Thank you.


146459-11.jpg146475-22.jpg


sql-server-reporting-services
11.jpg (106.6 KiB)
22.jpg (134.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered Willsonyuan-msft commented

Hi @KerryOu-8610

You need back up the Encryption key in the old reporting service configuration. and restore it in new report service configuration
146485-case-need.png
Best Regards,
Isabella


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



case-need.png (51.0 KiB)
· 13
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I already did this. But same problem.

0 Votes 0 ·

Hello KerryOu-8610,

Welcome to Microsoft Q&A, it worked in my environments. Did you try to restart the SQL Server report service after restore the encryption keys. As you can see, if we did not restore the encryption keys, all stored connection strings, credentials and encrypted values in subscription will be deleted. After deleting the encrypted content, we must redefine all data source connections and subscriptions used on the report server.

0 Votes 0 ·

Yes, I already restart the SQL Server report service. And than I try to delete and restore again. But same.Is there any other way? Thank you so much.

0 Votes 0 ·
Show more comments