Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This tutorial will help you to get started with SQL Server Reporting Services (SSRS)

Getting Started with SSRS (SQL Server Reporting Services)

Getting Started with SSRS - Part 4 - Configuring SQL Server Reporting Services in Windows Server 2008

Nov 12 2011 12:00AM by Karthikeyan Anbarasan   

Introduction

In our previous articles, we have seen how to install SQL Server Reporting Services and to create a new report using the Report Wizard and Report Designer Window. Now, in this article we are going to see how to configure SQL Server Reporting Services in Windows Server 2008 environment.

To deploy the report on a server and to use it across the environment we need to have the Report Server up and running. To do so we need to do some configuration for the report server. It will be covered in this article. Let us see the step-by-step process on the configuration of the SQL Server Reporting Services.

Steps

Considering that SQL Server Reporting Services (Denali or 2008 R2) is installed, we will step forward to do the configuration. Go to All Programs>> Microsoft SQL Server 2008 >> Configuration Tools>> Reporting Services Configuration Manager as shown in the screen below.

Launching Reporting Services Configuration Manager

The Reporting Services Configuration Manager will open as shown in the screen below.

Connecting to a Report Server Instance

Now we need to connect to the instance on which we need to configure the SQL Server Reporting Services. A pop-up window will appear prompting to select the Server Name and Instances Name. Select the appropriate Server and Instance Name and click on Connect as shown in the screen below.

Selecting the specified SQL Server Instance

Once connected successfully, we can see the Reporting Services instance running and option to start and stop the services. In addition, we can also see the details of the server running as shown in the screen below.

Starting the Report Server Instance

Now click on the Service Account on the left side menu to configure the account details. Here, we have two options to select the account details. If our server is domain controlled then we will go ahead with selecting the domain user name and password. Else, we can use the built-in account as shown in the screen below. Once we select the account click on Apply button to save the configuration.

Selecting the Service Account

Once we are done with the above configuration, click on to the next menu Web Service URL to configure the Virtual Directory. We can configure the virtual directory with any customized name or we can use the default name ReportServer and use the default configurations as shown in the screen below. Once we are done with the above configurations, click on Apply button to save the configurations

Configuring the Web Service URL

Now click on the next menu Database to create a new database or use an existing database for the SQL Server Reporting Services for saving all the reporting server data and application data for running the reports. Click on Change Database to select the database as shown in the screen below.

Selecting the Report Server Database

Once we click on the Change Database button, a new pop-up window will be displayed to configure the database. Here, we can select to either create a new database or use existing database as shown in the screen below.

Creating a New Report Server Database

Follow the basic steps used to create the database. Once the default steps are passed, we can see that the database is created as shown in the screen below.

Status of the New Report Server Database Creation

Now click on Finish button. We will see the database selected and the login details on to the main wizard as shown in the screen below. Once the required changes are done for the database, click on Apply to save the database configurations.

Summary of the Report Server Database

Now go to the next menu Report Manager URL and select the Virtual Directory. Name it as per the requirement, else by default we can use the one created by the server (Report) as shown in the screen below. Click on Apply once we are done with the configuration.

Configuring the Report Manager URL

Now we are done with all our configurations. To check if the configurations are done perfectly we need to navigate to http://<Servername>/Reports and check. Since in our article we have used the built in server we will try with http://localhost/Reports

If the configurations are done correctly, we will see the Report Server screen as shown in the screen below.

Report Manager URL in Action

In the above screen, we can see some of the projects deployed to the server, which we will cover in our next article.

Summary

Therefore, in this article we have seen how to configure the reporting services on to windows server 2008 server. In our next article, we will see how to deploy the Reporting project, which we created in Part 2 and Part 3 of this series.


Karthikeyan Anbarasan
52 · 4% · 1176
12 Readers Liked this
Jacob Sebastian Liked this on 11/30/2011 7:11:00 PM
Profile · Blog · Facebook · Twitter
Khyati Patel Liked this on 11/30/2011 11:46:00 PM
Profile · Facebook · Twitter
Jason Yousef Liked this on 12/1/2011 10:27:00 AM
Profile · Blog
Dinesh Sodani Liked this on 12/1/2011 11:34:00 PM
Profile · Blog · Facebook · Twitter
Shivendra Kumar Yadav Liked this on 12/2/2011 6:02:00 AM
Profile
Vivek Johari Liked this on 12/3/2011 7:12:00 AM
Profile · Blog
Abhijeet Desai Liked this on 12/6/2011 7:01:00 AM
Profile
Dhara Liked this on 12/13/2011 6:28:00 AM
Profile · Facebook
swethamandala Liked this on 12/15/2011 3:43:00 AM
Profile
Guru Samy Liked this on 3/23/2012 3:32:00 AM
Profile · Blog
Neha Mewara Liked this on 10/15/2012 8:19:00 AM
Profile
lokesh.chikkala Liked this on 11/22/2012 4:36:00 AM
Profile
12
Liked



Submit

3  Comments  

  • Thanks karthikeyan it helps alot....... is this require "sql authentication" for database? Can we use Windows authentication for database?

    commented on Dec 6 2011 7:04AM
    Abhijeet Desai
    328 · 0% · 129
  • I recently installed the developer version of SQL Server 2012. My operating system is Windows 7. I cannot seem to access The report server. When i click on the Web Service URL i get this message:

    "The permissions granted to user 'Paul-PC\Paul' are insufficient for performing this operation. (rsAccessDenied) Get Online Help "

    I have set the account to the local system, i tried switching the ip address to 127.0.0.1. NOthing seems to work...any ideas?

    commented on Jun 25 2012 9:06AM
    paulze2000
    1409 · 0% · 15
  • HI ,

    After i configured as above i have been asked for user name and password on clicking the report server url. I tried with all the blog tips. but am unable to resolve this. Could you please give me some solution.

    commented on Jul 6 2012 12:53AM
    Sreehari Katageri
    792 · 0% · 37

Your Comment


Sign Up or Login to post a comment.

"Getting Started with SSRS - Part 4 - Configuring SQL Server Reporting Services in Windows Server 2008" rated 5 out of 5 by 12 readers
Getting Started with SSRS - Part 4 - Configuring SQL Server Reporting Services in Windows Server 2008 , 5.0 out of 5 based on 12 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]