quinn johns

If you are using SQL Server Reporting Services (SSRS) as a reporting solution, and must change your device's PC name, SSRS may not correctly generate and display reports once the computer has been renamed. To correct this, perform the following steps: Open the Reporting Services Configuration Manager. Click the Database Tab. Modify the existing database, and simply follow the prompts. Once the procedures and steps are completed, try to re-run your Reports.

When attempting to duplicate a Report Server, from one system to another, you may encounter an issue that the keys do not match. The report server is unable to access encrypted data. Apply a back-up key or delete all encrypted content. (rsEncryptedDataUnavailable) (rsRPCError) To resolve the error, open the Report Server Configuration Manager , and select the Encryption Keys button on the sidebar. Back up encrypted keys from the primary server, transfer and load into current system. When attempting to restore a Report Server, when launching the reports you may encounter the following error message: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) To resolve the error, delete Keys table from the ReportServer database, then Stop and Start the Reporting Services, from the Report Server Configuration Manager , which will auto-create the system keys on the restart of the service.

In an unlikely circumstance that you happen to lose the Report Data Window , in SQL Server Business Intelligence, you won't simply find it in your VIEW menu options. There is a simple keyboard shortcut to re-create this window, which is CTRL+ALT+D .