SQL Server Reporting Services Configuration Manager

In SSRS, SQL Server Reporting Services Configuration Manager is used to configure the Reporting Services Native Mode installation. For instance,

• If we used the files only installation option to install the Report Server. Then before we intend to use it, We must use SQL Server Configuration Manager to configure the SSRS Reporting Services.
• If we used the default settings to install the Report Server, We could use this Configuration Manager to modify the default setting of a Reporting Server.
• While installing the SQL Server, if you install SSRS Reporting Services with the default settings using checkboxes, you must configure the options using Configuration Manager. This process is not complex, but you must follow the steps carefully. 

This article will show you how to set up SQL Server SSRS Reporting Services Configuration Manager with screenshots.

SSRS Report Manager uses

The SSRS Reporting Services Configuration Manager is useful for performing the following tasks:

• Configuring the Report Server Service Account: By default, we provide default account details while we initially set up the reporting server. But using the SSRS SQL Server Reporting Services Configuration Manager, we can add a new account or change the password.
• Create or Configure the Report Server Database: By default, the Reporting server generates two Databases (ReportServer and ReportServerTempDB) for internal storage. We can use the SSRS Reporting Services Configuration Manager to create a New Database or to manage the existing Database.
• Symmetric Keys: We can use the SQL Server Reporting Services Configuration Manager to back up, restore, or replace the SSRS symmetric key. These keys are used to encrypt stored connection strings and credentials.
• Configure Web server URLs: We can use the SQL Server Reporting Services Configuration Manager to configure the Web server URLs for each SSRS application. It is the URL we will use for, Deploying SSRS Projects or Reports.
• Configure Report URLs: We can use the SSRS Configuration Manager to configure the Report URLs for each application. It is the URL we will use for, Viewing or Securing SSRS Projects or Reports.
• Configuring Email: Use the SSRS Reporting Services Configuration Manager to configure the SMTP Server. The SMTP Server sends Emails about report processing, report delivery, etc.

Setup SSRS SQL Server Reporting Services Configuration Manager

If you are using Windows 7, then go to All Programs, or If you are using Windows 8 or a later version, then go to installed applications. Next, click on the SSRS SQL Server Reporting Services Configuration Manager.

Once click on it, It will open the SSRS Reporting Services Configuration Manager window along with the Connection window. Use this to select the Server Name and Reporting Server Instance Name.

Here, we select our Default Instance Name and Suresh as Server Name.

SQL Server Reporting Services Configuration Manager Status

It displays the Current Report Server information such as Database Name, SQL Server Instance Name, Id, Version, and Server Status. We can use this page to Start or Stop the Reporting Server using those two buttons.

TIP: We can use the Service Account tab to change the existing account or create a new account for the reporting server.

SSRS Reporting Server URL for Web Service

In SQL Reporting Services Configuration Manager, Web service URLs and SSRS Report Manager URLs are used to access the Server Web service and Manager.

By default, Reporting Services provides default URLs, but you can change them as per your requirement.

NOTE: This is the URL we are going to use for Deploying Reports or SSRS Projects

By clicking the advanced button, you can change the TCP Port from default 80 to other. You can change the IP address to the network name by clicking Add, Remove, and Edit buttons.

SSRS Report Manager URL

In SSRS Configuration, SQL Server Report Manager URL is used to access the Web service and Report Manager. By default, Reporting Services provides a default URL. However, you can change them per your requirement by clicking the Advanced button.

The following screenshot will be displayed after you click on the above URL. It is the place where we can see the deployed reports, Shared Datasets, and Shared Data Sources.

NOTE: The port number is optional in the Report Manager URL. Some systems may ask for the port number, and some may not.

SQL Server Reporting Services Configuration Manager Database Setup

If you go to the Database tab, you can see the current Reporting server database name, modes, and also the credentials used for that. From the below screenshot, you can observe that ReportServer is the default Database name.

In this SSRS Report Manager example, we will show you the steps to change the default database name, so click on the Change Database button.

Once you click the Change Database button, a new window called Report Server Database Configuration Wizard will open to create a new database.

Within the Actions tab, you have to select the required option from the list:

• Create a New Report Server Database: If you want to create a new underlying database for the report server’s internal storage, Please select this option. We are choosing this option because we are creating a new database.
• Choose an Existing Report Server Database: If you want to modify the existing database of a report server, then Please select this option.

Connect SSRS Report Manager to Database Server

This tab is used to specify the Server Name, Authentication Type, User Name, and Password required to connect with the Database.

Click on the Test Connection button to test the SSRS Reporting Services Configuration Manager connection we provided.

From the above screenshot, we see our connection is successful. Now, click on the Next button to go to the Database tab.

Here, we have to specify the new database name per your requirement. For now, we named it as New Report Server, as shown below.

Click on the Next button to go to the Credentials tab. Here we have to select the Authentication Type. SSRS SQL Server Reporting Services Configuration Manager provides the following types of authentication:

• Windows Credentials: Please choose this option while working on the local computer. Here you must have permission to access the Database.
• SQL Server Credentials: Please select this option, If you want to connect to the external Database. Here we must provide the username and password required to connect with the server. Here the credentials should match the user data in SQL security.
• Service Credentials: If you want the reporting server to connect using the service account, please select this option. Here, credentials are not encrypted or stored.

Click on the Next button to go to the Summary tab. Here we can see the summary of the created database.

Click on the next button to create the database.

Click the Finish button to finish creating a new Reporting server Database.

From the below screenshot, you can see the new database name