70-448 · Question #75
You are developing SQL Server 2008 Reporting Services (SSRS) samples which include some reports which utilize stored credentials to get data from a SQL Server 2008 sample for Company.com. There is…
The correct answer is B. You should recovery the encryption keys. When faced with a system failure where you lose your SSRS instance and/or database, you will: first need to reinstall SSRS. After the installation is complete, you can optionally restore the latest backup of your report server catalog database (if it was also lost). After the…
Question
You are developing SQL Server 2008 Reporting Services (SSRS) samples which include some reports which utilize stored credentials to get data from a SQL Server 2008 sample for Company.com. There is the instance recovers and SSRS instance in a computer. You should make sure that the reports could run normally. Which is the correct answer?
Options
- AYou should delete the encryption keys and create new ones.
- BYou should recovery the encryption keys.
- CYou should change the encryption values.
- DYou should reset the encryption default values.
How the community answered
(35 responses)- A3% (1)
- B71% (25)
- C17% (6)
- D9% (3)
Explanation
When faced with a system failure where you lose your SSRS instance and/or database, you will: * first need to reinstall SSRS. * After the installation is complete, you can optionally restore the latest backup of your report server catalog database (if it was also lost). * After the service and catalog databases are in place, * your final step is to restore the encryption key onto the newly installed instance of SSRS. This will enable the report server to be able to decrypt the catalog security, reports, and data sources.
Topics
Community Discussion
No community discussion yet for this question.