What is reporting server configuration manager and what all configuration options are available inside the configuration manger?

Problem: What is reporting server configuration manager and what all configuration options are available inside the configuration manger?

Solution: Reporting Services Configuration Manager (Native Mode)

Reporting Services Configuration Manager is a configuration tool to set properties of the reporting server URL where all the reports get deployed and the database used to store the properties of each report and data sets. Etc.

Sometimes when you want to create or verify settings of the reporting server database or reporting server URL. You may have to open the reporting server configuration manger to see how things are configured.

Reporting Services configuration manager can be opened if there is a reporting service installed on the local machine or server machine. Browse under Microsoft SQL Server folder in the installed programs or search of Reporting services configuration manger in the windows search

After you click this opens the configuration manager tool

As we can see it has few tabs and each tab has few tasks which can u can use the Reporting Services Configuration Manager to perform the following tasks: 

·         Configure the Report Server service account. The account is initially configured during setup, but can be modified by using the Reporting Services Configuration Manager if you update the password or want to use a different account.

·         Create and configure URLs. The report server and the web portal are ASP.NET applications accessed through URLs. The report server URL provides access to the SOAP endpoints of the report server. The web portal URL is used to open the web portal You can configure a single URL or multiple URLs for each application.

·         Create and configure the report server database. The report server is a stateless server that requires a SQL Server database for internal storage. You can use the Reporting Services Configuration Manager to create and configure a connection to the report server database. You can also select an existing report server database that already contains the content you want to use.

·         Configure a Native mode scale-out deployment. Reporting Services supports a deployment topology that allows multiple report server instances use a single, shared report server database. To deploy a report server scale-out deployment, you use the Reporting Services Configuration Manager to connect each report server to the shared report server database.

·         Backup, restore, or replace the symmetric key that is used to encrypt stored connection strings and credentials. You must have a backup of the symmetric key if you change the service account, or move a report server database to another computer.

·         Configure the unattended execution account. This account is used for remote connections during scheduled operations or when user credentials are not available.

·         Configure report server e-mail. Reporting Services includes a report server e-mail delivery extension that uses a Simple Mail Transfer Protocol (SMTP) to deliver reports or report processing notification to an electronic mailbox. You can use the Reporting Services Configuration Manager to specify which SMTP server or gateway on your network to use for e-mail delivery.

The Reporting Services Configuration Manager does not help you manage report server content, enable additional features, or grant access to the server. Full deployment requires that you also use SQL Server Management Studio to enable additional features or modify default values, and the web portal to grant user access to the server.

Example:

In this article, I am going to show we can create a custom reporting server database to save the properties of the reporting server datasets and data sources.

Step 1: Open the reporting server configuration manager go to the database section on the left-hand side.

Step 2: Click on change and you would be prompted with a database wizard and from the options to choose create or existing database, click on create database button.

Step 3: enter the database server and select the authentication type to choose.

Step 4: in the database name section enter the new database name to create.

Results:

 

Go to the SQL Server Management Studio to see whether the new database has been created or not.