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 intended to use it, We must use Configuration Manager to configure the Reporting Server
- 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.
In this article, we will show you how to set up SQL Server Reporting Services Configuration Manager with screenshots.
SSRS Report Manager uses
The SSRS Configuration Manager is useful to perform 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 SQL Server Reporting Services Configuration Manager, we can add a new account, or we can 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 SQL Server 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 Backup or restore or replace the 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 application. It is the URL we are going to 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 are going to use for, Viewing or Securing SSRS Projects or Reports.
- Configuring Email: Use the SQL Server Reporting Services Configuration Manager to configure the SMTP Server. The SMTP Server is used to send Emails about report processing or report delivery etc.
Configure SQL Server Reporting Services Configuration Manager
If you are using Windows 7, then go to All Program, or If you are using Windows 8 or later version, then go to installed applications. Next, click on the SQL Server Reporting Services Configuration Manager.
Once click on it, It will open the Reporting Services Configuration Manager window along with the Reporting Services Configuration Connection window. Use this to select the Server Name and Reporting Server Instance Name.
Here, We are selecting our Default Instance Name and Suresh as Server Name.
SSRS Report Server Status
It displays the Current Report Server information such as Database Name, SQL Server Instance Name, Id, Version, and the 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 to 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 Report Server Web service and Report 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 Reporting, SSRS Report Manager URL is used to access the Report Server Web service and Report Manager. By default, Reporting Services provides a default URL. However, you can change them as per your requirement by clicking the Advanced button.
NOTE: Port number is optional in the Report Manager URL. Some systems may ask the port number and some may not
SSRS Report Manager Database Configuration
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 example, we will show you the steps to change the default database name so, click on the Change Database button
Once you click on 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 report server internal storage then, Please select this option. Here, 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 connection we provided.
From the above screenshot, 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 as 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 Reporting Server provides the following types of authentication:
- Windows Credentials: Please choose this option while you are 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 have to provide the username and password required to connect with the server. Here the credentials should match the user data in SQL security.
- Service Credentials: Please select this option, If you want the reporting server to connect using the service account. 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