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

Preface

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.

 

Steps

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.

 

 

rsreportserver.config

rsreportserver-config-20161213-0637PM

 

Explanation

  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

 

Database

RSConfig-Database-brushedup-20161213-0625PM

 

 

Report Server Configuration Wizard

Action

The Action tab appears….

RSConfig-Database-ChangeDatabase-20161213-0626PM

 

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.

 

Database

 

SelectAReportServerDatabase-brushedup-20161213-0639PM

 

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

 

Credentials

Credentials-20161213-0640PM

 

In our case, we kept everything as is.

 

Summary

Summary-brushedup-20161214-0627AM

 

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…

ProgressAndFinish

 

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