You need to ensure that the reports hosted on the instance continue to function correctly

You administer a SQL Server 2008 Reporting Services (SSRS) instance. The instance
contains several reports that use stored credentials to access data from a SQL Server 2008
instance. A computer that hosts the instance recovers from a hardware failure and has a
newly installed SSRS instance. You need to ensure that the reports hosted on the instance
continue to function correctly. What should you do?

You administer a SQL Server 2008 Reporting Services (SSRS) instance. The instance
contains several reports that use stored credentials to access data from a SQL Server 2008
instance. A computer that hosts the instance recovers from a hardware failure and has a
newly installed SSRS instance. You need to ensure that the reports hosted on the instance
continue to function correctly. What should you do?

A.
Reinitialize the Report Server.

B.
Restore the encryption keys.

C.
Recreate the Report Server database.

D.
Recreate the encryption keys.

Explanation:
Managing the Encryption Keys is a core to any SQLRS database recoveries that may need
to be done. It is therefore recommended that those responsible for supporting SQLRS

instances familiarise themselves with the concepts discussed SQLRS Books Online (BOL)
under “Managing Encryption Keys” During setup SQLRS creates encryption keys, which are
then used to secure credentials, connection information, and accounts that are used in
server operations. As soon as you finish installing SQLRS, you should make a copy of the
symmetric key. If you ever need to repair a Reporting Services installation due to changes in
computer name, instance name, or user account values, you can apply the key to make the
report server database operational.



Leave a Reply 0

Your email address will not be published. Required fields are marked *