SQL Server – Reporting Services–Configuration- Backend DB Instance Change


If you end up having to change the computer name that backends your Reporting Services (RS), you will have to let your RS know about it.



Configuration Files

Unfortunately, you have to do more than hand change the configuration files.

The reason being the fact that your Database Connection settings are encrypted.

One might wonder why the secrecy, and MSFT might have one think through the fact that two types of authentication are supported.

And, those are Integrated Authenthication and the SQL Native authentication.

SQL Native Authentication relies on clear text username and passwords.







  1. DSN
    • The element that contains the backend database is appropriately name DSN, Datasource Name
    • As aforementioned it is encrypted
  2. URL Reservation
    • There are a couple of other elements to tend to and those have to do with the HTTP Endpoints
      • There are two important end points and those are ReportServeWebService and ReportManager
      • From the screenshot above we can see that they are both listening on the local host’s port 80
      • There IIS Application names are also shown



Reporting Services Configuration


  1. Launch Reporting Services Configuration Manager
  2. Navigate to the Database tab
    • Click on the Change Database button
  3. The “Report Server Coniguration Wizard” appears






Report Server Configuration Wizard


The Action tab appears….



Please choose the “Choose an existing report server database”.


Database Server

RSConfig-Database-ConnectToDatabase (brushed up)-20161213-0638PM


Please replace the former computer name with the revised name.

And, be sure to validate your connection by clicking on the “Test Connection” button.






Please be sure to transverse to the appropriate Report Server database; by default the name of that database will be ReportServer.





In our case, we kept everything as is.





The summary screen offers you the last opportunity to review your selections.

Please pay particular attention to your “SQL Server Instance” and “Report Server Database”.


Progress and Finish

Next comes the actual processing of your request…



You will like to see that all tasks came back successful.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s