Join Dotnetcodes DotnetCodes.com is online Discussion Forum for Software professionals . It lets you find friends around the world and Create professional network that share similar interests as you. Get help on ur projects by industry specialists. Also get answers to all ur technical/placement related querries.Get an edge over others.
Already MemberClick here to login
ASP.net MVC Interview Questions Answers Interview Questions
Get Started Developing for Android Apps with Eclipse Articles
Serial Number in SSRS Articles
.Net framework 4.0 Interview Questions Answers Interview Questions
SQL server reporting services Interview Questions (SSRS) part 1 Articles
Whats New in ASP.NET 4.0 Part 2 Articles
How to Print a Crystal Report direct to printer Articles
Difference between Encapsulation and Abstraction Interview Questions
Explaining SDLC -System Development Life Cycle Articles
Html5 interview questions and answers Interview Questions
SharePoint 2010 interview Questions Answers Interview Questions
Infosys Interview Questions Interview Questions
Dynamic Menu using HTML List Tag and CSS in ASP.Net Articles
Populate or bind Dropdownlist in Asp.net using Jquery and Json Articles
ASP.NET MVC Overview Interview Questions
Submit Articles | More Articles..

SQL Server Report Server configuration

Posted By: rakesh On:3/27/2012 1:10:37 AM in:Articles Category:ASP.NET Hits:3089
This Article show, how to setup and configure sql server reporting service with sql server 2008 R2

SSRS Setup  & Configurations

System Requirements

The setup and configuration for this demo involves the following tasks:

  • Task 1 – Running Configuration Wizard
  • Task 2 – Configuring Report Server
  • Task 3 – Configuring Basic Authentication in Reporting Services
  • Task 4 – Deploying AdventureWorks Sample Reports
  • Task 5 – Browsing the Reports

Task 1 – Running the Configuration Wizard

The following steps describe how to run the Configuration Wizard tool included with the demo to verify that all the prerequisites are properly installed.

  1. Browse to the setup folder in the Source folder of this demo, and run theSetup.cmd script. This script will launch the Configuration Wizard for the demo. The Configuration Wizard is designed to check your computer to ensure that it is properly configured with all of the dependencies needed to run the demo.
  2. Click through the steps in the Configuration Wizard to get to the Detecting Required Software step, a scan of prerequisites will be performed on your computer. If you do not have the necessary dependencies, install them using the links provided by the tool and rescan your computer.

    Figure 2 Dependencies check completed successfully

  3. Once the required software is properly installed click Next to configure your computer for this demo. A script will be executed to deploy a custom style sheets into the reports server (you will be prompted to enter the Report Server instance name) and another to create the server alias ('SQLServerTrainingKitAlias') used in this demo to establish a connection with the database.

    Figure 3 Configuration Wizard tasks

Task 2 – Configuring the Report Server

  1. Open Reporting Services Configuration Manager from Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools.

  2. In the “Connect to a report server instance” dialog box, make sure that your local report server instance (for example MSSQLSERVER) is selected and clickConnect.

    Figure 4 Reporting Services Configuration Manager connection

  3. On the Web Service URL () page, make sure that the Virtual Directory is set to ReportServer_%YourSqlServerInstanceName% (for example ReportServerfor the SQL Server default instance) and that the TCP Port is set to 80.

    Figure 5 Web Service Configuration

  4. On the Database page(), make sure that:
    1. SQL Server Name points to your local SQL Server instance (for examplelocalhost\.).
    2. Report Server Mode is set to Native.

    Figure 6 Database Configuration

  5. If the Database Configuration values are not set as above, follow these steps:
    1. Click Change Database to open the Report Server Database Configuration Wizard.
    2. Click Create a new report server database and then Next.
    3. In the Database Server page, set the Server Name to point the local SQL Server instance (for example SQLExpress) and select Current User -Integrated Security for the Authentication Type.

      Figure 7 Change Database Server Configuration

    4. Click Next.
    5. In the Database page, type ReportServer as the Database Name and click Native Mode for the Report Server Mode.

      Figure 8 Change Database Configuration

    6. Click Next to continue.
    7. In the Credentials page, select Service Credentials for theAuthentication Type.

      Figure 9 Change Database Configuration

    8. Click Next, and finally Finish to complete the wizard.
  6. On the Report Manager URL page (), make sure that the Virtual Directory is set to ReportServer_%YourSqlServerInstanceName% (for exampleReportServer for the SQL Server default instance).

    Figure 10 Database Configuration

  7. Click Exit to close the Configuration Manager.

Task 3 – Deploying the AdventureWorks Sample Reports

  1. Open Business Intelligence Development Studio from Start | All Programs | Microsoft SQL Server 2008 R2 with administrative privileges.
  2. Click the File menu, point to Open and then click Project/Solution.
  3. Browse to %ProgramFiles%\Microsoft SQL Server\100\Samples\Reporting Services\Report Samples\AdventureWorks 2008R2 Sample Reports, select the file AdventureWorks 2008 Sample Reports.sln and click Open.

    Figure 11 AdventureWorks2008 Sample Reports in Business intelligence Development Studio

  4. On the Visual Studio toolbar, select Release in the Solution Configurations (the default configuration is Debug).

    Figure 12 Release Configuration

  5. Right-click the AdventureWorks 2008R2 project and select Properties.
  6. On the General tab, configure the General properties as follows:
    1. Set OverwriteDataSources to True
    2. Set TargetReportFolder to AW2008SampleReports
    3. Set TargetServerURL to http://<servername>/reportserver

      Figure 13 Project Configuration

  7. Click OK.
  8. In Solution Explorer, under the Shared Data Sources folder, double-clickAdventureWorks2008R2.rds to open the Adventure Works Data Source Properties.
  9. Under the General page, modify the Connection String to use theSqlServerTrainingKitAlias server alias.

    Figure 14 Data Source Configuration

  10. Click OK.
  11. On the Build menu, click Deploy AdventureWorks 2008R2.

Task 4 – Browsing the Reports in the Report Manager

  1. Open Internet Explorer with administrator privileges.

  2. Browse the Report Manager at http://localhost/reports.
  3. In the Home page, click the AW2008SampleReports folder. You should see all AdventureWorks2008 Sample Reports.

    Figure 15 AdventureWorks2008 Sample Reports in Report Manager

comments powered by Disqus
User Profile
Rakesh Sinha
Sr. Technical Lead
New Delhi , India
Email :You must Log In to access the contact details.
Latest Post from :rakesh
Response.Redirect vs Server.Transfer
View: 396 | Submitted on: 12/27/2015 2:26:38 PM
The test form is only available for requests from the local machine.
View: 438 | Submitted on: 11/3/2015 9:54:36 PM
Difference between web service WCF and Web API
View: 5502 | Submitted on: 10/28/2015 9:23:51 PM
Which party you want to vote in Delhi assembly elections 2015?
View: 1433 | Submitted on: 12/18/2014 4:19:24 AM
How to Calculate sum of a column in a dataset
View: 1101 | Submitted on: 9/17/2014 6:48:19 AM
Submit Articles | All Post of This User..

All rights reserved to dotnetcodes. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
Best viewed at 1024 x 768 resolution with Internet Explorer 5.0 or Mozila Firefox 3.5 or Google Crome and higher