The Database You Have Selected Is Not A Report Server Database

In the Report Server Database Configuration Wizard, you can encounter the following error message when selecting an existing report server database after clicking Change Database: Error The database you have selected is not a report server database. Please select a SQL Server database that contains report server specific tables and stored procedures and try again. […]
Continue reading…

 

The Report Server Installation Is Not Initialized. (rsReportServerNotActivated)

After electing to use an existing Reporting Services Report Server database, you may get the following error: The report server installation is not initialized. (rsReportServerNotActivated) This can be easily fixed by opening the Keys table in the Report Server database in SQL and deleting the row that contains the name of the old Reporting Services […]
Continue reading…

 

SQL Reporting Services – Applying Connection Rights Error

When changing the database in SQL Reporting Services, you can sometimes get an error in the Report Server Database Configuration Wizard around applying connection rights. This is because the account used to enable the connection to the database doesn’t have the right level of permissions in SQL Server. To fix this, connect to the SQL […]
Continue reading…

 

Custom Extensions Or Assemblies Were Detected On The Report Server – SQL 2008 R2 Upgrade Advisor

When upgrading an existing installation of MSSQL to Microsoft SQL 2008 R2, the SQL Upgrade Advisor may highlight the follow issue with Reporting Services: Custom extensions or assemblies were detected on the report server This error occurs because there has been some custom extentions or assemblies installed into the current version of SQL Reporting Services. This […]
Continue reading…

 

The Report Server Cannot Access The Private Key For The Service Account In Reporting Services

After changing the password for the SQL Reporting Services account, I now have the following error when I visit the report manager URL: The report server cannot access the private key for the service account. This key is used to decrypt the symmetric key that protects content in the report server database. This condition might […]
Continue reading…