Ensure that SSRS can access the Reporting Services database

Procedure 8 of 23 associated with Step 2 - Change the Computer Name, Domain, or Workgroup of an individual managed server Server that is managed by the Enterprise Manager application..

Perform this procedure only if you are changing the name of the computer running SQL Server that hosts the Reporting Services Server role in the Data Center that provides reporting services for Workforce Management (WFM), Scorecards, eLearning, Coaching, Customer Feedback, Interactions and Speech Analytics products. database. Otherwise, skip this procedure and continue to Change the server name on the server Settings screen.

In this procedure, you use the Reporting Services Configuration Manager to ensure that SSRS can access the Reporting Services database on the renamed computer running SQL Server.

Perform this procedure from the server that hosts the Reporting Services server role Entity that contains a logical, predefined set of components (system software or certified third-party software) deployed in the Data Center and Site Zones that provide specific functionality for the system..

  1. Launch the Reporting Services Configuration Manager.

    (Usually located at Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > Reporting Services Configuration Manager.)

  2. In the left pane, select Databases.

  3. Select Change Database.

    The Report Server Database configuration wizard opens.

  4. Select Choose an existing report server database and click Next.

    The Database Server settings display in the right pane.

  5. In the Server Name field, enter the new name of the server that hosts the Reporting Services database.

  6. Verify that Authentication Type is set to Current User-Integrated Security, and then click Test Connection.

    The database connection is tested.

    • If the connection succeeds, a page will indicate a successful connection. Click OK to close the page.

    • If the connection fails, you must diagnose the connection issue and retry the connection test.

    After successfully testing the connection, click Next.

  7. At the Select a report server database screen, do the following:

    • For Report Server Database, select ReportServer (the Reporting Services database).

    • Click Next.

  8. In the right pane, the Credential settings display. Do not change any settings on this page. Click Next.

  9. In the right pane, the Wizard Summary displays. Click Next.

    The database configuration launches, and the status is displayed in the right pane. When the configuration completes, Finish is enabled.

  10. Click Finish. The Reporting Services Configuration Manager page is displayed again.

What to do next 

Restore the SSRS Encryption Key