Please go through following steps:
1. In the start menu go to Microsoft Sql Server 2008 R2 -> Configuration Tools, then click Reporting Service Configuration Manger.
2. In Reporting Service Configuration Connection, Select or Enter Server Name and Report Server Instance, then click on Connect.
3. In Report Server Status verify that the Service Status is set to Running. If it is not started, click on Start, and then click on Apply.
4. In Service Account Pane, you can set service account like Local System, if you want it to run only in local system or Network Service, if you want it to run on your Network.
5. In Web Service URL Pane, specify the name which you want to call the virtual directory created by Reporting Services or you can use the default Report Server or you can select the IP-address, the port and SSL setting you want to use. When done click on Apply.
6. In Database Pane, select existing Report Server Database or You can also create a new Report Server Database.
7. In Report Manager URL Pane, specify the name which you want to call the virtual directory created by Reporting Services or you can use the default Report Server or you can select the IP-address, the port and SSL setting you want to use. When done click on Apply.
8. Email settings are not mandatory but you can configure if it is necessary for you.
9. Execution Account is necessary to configure if you will be running unattended reports. Optionally apply credentials and Click Apply.
Congratulations! We have successfully configured Sql Server 2008 Reporting Services.
If you click on the above URL then following Screenshot will be displayed. This is the place where, we can see the deployed reports, Shared Datasets and Shared Data Sources.
Once you click on the Change Database button, a new window called Report Server Database Configuration Wizard will be opened to create new database.
Click on the Test Connection button to test the connection we provided.
From the above screenshot you can observe that, our connection is successful. Now, click on the Next button to go to Database tab
Click on the Next button to go to Credentials tab. Here we have to select the Authentication Type. Reporting Server provides following types of authentication:
Click on the Next button to go to Summary tab. Here we can see the summary of the created database
Click on the next button to create the database.
Click finish button to finish creating new Reporting server Database
From the below screenshot, you can see the new database name
Configuring SQL Server Reporting Services in SQL Server 2012
In yesterday’s blog
I showed the error when I tried to login to SSRS through Management
Studio. I recollected that while installing SQL Server, I chose the
option Install only, and I did not configure Reporting Services until
now.
So, I
decided to write a blog with step by step explanation of how to
configure SQL Server Reporting Services. This blog explains the steps to
perform on a SQL Server 2012 (as of RC0) and the steps are similar to
the steps to configure SQL Server 2008 R2 Reporting Services.
Before
configuring SQL Server Reporting Services, ensure that your login has
administrator permissions on which the Reporting Services is being
configured and also ensure that you have required permissions to create
databases (ReportServer databases) on the SQL Server when ReportServer
databases will reside.
Go to Start, SQL Server 2012 (RC0 in this case), for other versions of SQL Server choose the appropriate program menu. Go to Configuration Tools and click on Reporting Services Configuration Manager (pic below).
In the next dialog, choose the Server Name and Instance (if more than 1 instance is installed, select the instance from the drop down) and click connect.
Once the
Configuration Manager is connected successfully, the Report Server
Status is displayed as shown below…. You can see the current status of
the Reporting Service and Stop or Start depending on the current status.
Click on Service Account,
in the left side pane. The current Service Account setting is
displayed. Be default, this would be a service account that was chosen
at the point of SQL Server Installation. You can change the service
account to another account by choosing Use another account
option and enter the username password for that account. I chose to let
the Reporting Service run under the service account created during
Installation. Once you are done with your choice click Apply button in the bottom of the window.
As soon as you choose apply, few steps are run and the results are displayed as shown in this screen below.
Next, click on web Service URL. The default values are already assigned, and if we decide those vales are good enough, choose Apply to configure with the default values. Instead you can choose a virtual directory of your choose and click Apply when your changes are final.
Note: I am choosing a basic configuration, so I am continuing with default values…
Once the configuration tool configures
the virtual directory, the Report Server Web Service URLs are now active
and you should be able to click on the URL (in blue font) to open the
URL.
Next, click Database.
This is the configuration step in which you configure what SQL Instance
is hosting the Reporting Services Report databases. Since the databases
are not configured, note that the values are blank. Click Database to
start configuring databases.
Once you
click change database, a new wizard Report Server Database Configuration
is displayed as below. In the first screen, there are 2 options, if you
would like to create new databases for this reporting service, choose
the first option. If you would like to point to an existing report
server database, choose the 2nd option. In this case I am going to
create new databases for the report server, so I chose that option,
click Next to continue…
The next
step in the wizard will display the SQL Instance name (if the server has
database engine installed), choose the authentication type and click Next.
Enter the database name for the report Server database and click Next.
In the
next step, choose the Credentials you would like the report server to
use while connecting to the report server database. By default Service
Credentials is provided, choose Next to use the Service Credentials.
In the next summary screen verify that all settings, selections are as per your plan and click Next to begin the database creation and configuration step.
Once all the steps are successful, the wizard will display the below screen, click Finish to complete the database configuration.
As the database configuration is completed, you should now see Server Name, database name and other details (as below).
Next click Report Manager URL,
This is the step where you can configure the URL for Report Manager.
Again this is completely optional, I chose to go with default values, so
click Apply.
Once the Report Manager URL is configured, the results section should be displaying the success messages as shown below..
The Next step to configure is E-mail Settings.
In this step, you must provide sender email address to be used by the
Report Server and provide the SMTP Server information in your case. In
this case I do not have SMTP Server configures on my personal Server. I
choose to skip this step and not configure any email settings.
In the next step, Execution Account,
you will have to provide a domain account (preferably) to be used in
case of any credentials are required. The domain account has to have
sufficient permissions to access the report items / files. I am not
planning to configure this as of this point, so I am skipping this step.
In the next step, Encryption Keys,
you have choice to Backup your Reporting Server’s Encryption key to a
file, in order to use, in case of migration to another server. In
addition to this, if you have create a new Encryption Key or delete the
existing Encryption Key ( as and when the situations arise).
The final step in the configuration tool is Scale-out Deployment.
This is the step where more than 1 Reporting Services will be utilizing
the same Report Databases. You will have to use this step after you
finish installing other Reporting Instances and join those instances
into the scale-out deployment.
SQL Server Reporting Services Configuration Manager 2014
by suresh
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, We must use this Configuration Manager to configure the Reporting Server before we intended to use.
- If we used the Default settings to install the Report Server, We can 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 2014 with screenshots. Reporting Services Configuration Manager is very useful to perform the following tasks:
- Configuring the Report Server Service Account: By default we provide default account details while we initially setup the reporting server, but using the SQL Server Reporting Services Configuration Manager we can add new account or we can change the password.
- Create or Configure the Report Server Database: By default, Reporting server generates two Databases (ReportServer and ReportServerTempDB) for internal storage. We can use the SQL Server Reporting Services Configuration Manager to create 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 that is 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. This is the URL we are going to use for, Deploying SSRS Projects or Reports
- Configure Report URLs: We can use the SQL Server Reporting Services Configuration Manager to configure the Report URLs for each application. This is the URL we are going to use for, Viewing or Securing SSRS Projects or Reports.
- Configuring E-mail: We can use the SQL Server Reporting Services Configuration Manager to configure the SMTP Server, which is used to send Emails about report processing or report delivery so on.
Steps to Configure SQL Server Reporting Services Configuration Manager 2014
If you are using Windows 7 then goto All Program or If you are Windows 8 user then goto to installed applications and Click on the SQL Server 2014 Reporting Services Configuration Manager as shown below
Once click on it, It will open Reporting Services Configuration Manager window along with Reporting Services Configuration Connection window to select the Server Name andReporting Server Instance Name. Here, Wer are selecting our Default Instance Name and Suresh as Server Name as shown below.
Report Server Status
This will display 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 new account for the reporting server.
Web Service URL
In Reporting Services, Web service URLs and Report Manager URLs are used to access the Report Server Web service and Report Manager. By default, Reporting Services provides default URLs as shown below 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 and IP address to network name by clicking Add, Remove and Edit buttons.
Report manager URL
In Reporting Services, 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 by clicking the Advanced button.
If you click on the above URL then following Screenshot will be displayed. This is the place where, we can see the deployed reports, Shared Datasets and Shared Data Sources.
NOTE: Port number is optional in the Report Manger URL. Some systems may ask the port number and some may not
Database Configuration
If you goto 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 be opened to create 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 selecting this option because we are creating 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.
Database Server
In this tab we have 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 you can observe that, our connection is successful. Now, click on the Next button to go to 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 Credentials tab. Here we have to select the Authentication Type. Reporting Server provides following types of authentication:
- Windows Credentials: Please select this option, If you are working on local computer and you have permission to access the Database.
- SQL Server Credentials: Please select this option, If you want to connect to external Database. Here we have to provide the username and password required to connect with the server and these 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 Summary tab. Here we can see the summary of the created database
Click on the next button to create the database.
Click finish button to finish creating new Reporting server Database
From the below screenshot, you can see the new database name
Thank You for visiting Our Blog
