SQL Server cannot open a connection to the report server database

Case Environment:

Operating system version: Windows Server R2 Standard

Database version: SQL SERVER SP2

Case Description:

The following error message appears when you enter the Reporting Service management interface for a newly installed SQL Server server today

The report server cannot open a connection to the report server database. A connection to the database are required for all requests and processing. (rsreportserverdatabaseunavailable) Get Online Help

The final discovery was that the installation of the reporting service was checked for "Install but does not configure" during SQL Server Setup, and Reporting Services must be configured before using the reporting service. Execute the following command in the Command window (the corresponding account number, password according to the specific circumstances of the replacement)

Rsconfig-c-S <SQLSERVERNAME>-D reportserver-a windows-u <MYDOMAIN\MYACCOUNT>-P <PASSWORD>

See MSDN for an Introduction to the RSConfig utility (SSRS). After executing the command, go to the admin interface and the following error occurs

The report server cannot decrypt the symmetric key, is used to access sensitive or encrypted data in a report server D Atabase. You must either restore a backup key or delete all encrypted content. (rsreportserverdisabled) Get Online help Keyset does not exist (Exception from hresult:0x80090016)

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in the report server database. You must restore the backup key or delete all encrypted content, and then restart the service.

To perform the steps:

Step 1: Open the Reporting Services Configuration Manager and go to the encryption key option.

Step 2: Click the "delete" button to delete the encrypted content

Step 3: Click on the "Change" button

Step 4: Restart Reporting Services, problem solving.

SQL Server cannot open a connection to the report server database