Install and Configure SQL Server Reporting Service (SSRS)

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

Install and Configure SQL Server Reporting ServiceIn this article, I will elaborate

How to install and configure SQL Server Reporting Service (SSRS) Native Mode.

Applies To: 
  • SQL Server Reporting Services SSRS 2016.
  • SQL Server Reporting Services SSRS 2014
  • SQL Server Reporting Services SSRS 2012.
  • SQL Server Reporting Services SSRS 2008.


Steps:

Install SQL Server Reporting Services SSRS

In this article, I considered you already have installed SQL Server.

To instal SQL Server 2012 check,  SQL Server 2012 Setup

  • Mount your SQL Server Media ISO/CD > Run SQL Server Installation file > From SQL Server Installation Center > Click on Installation.

Install and Configure SQL Server Reporting Services - Installation

  • Click on New SQL Server stand-alone installation or add features to an existing installation.

Install and Configure SQL Server Reporting Services - New SQL Server

  • Click OK after the Setup Support Rules have been passed.

Install and Configure SQL Server Reporting Services - Setup Support Rules

  • Check Product Updates and click Next.

Install and Configure SQL Server Reporting Services - Product Updates

  • Again, Check Setup Support Rules and click Next.

Install and Configure SQL Server Reporting Services - Rules

  • From Installation Types > Check Perform a new installation.

Install and Configure SQL Server Reporting Services - Installation Type

  • From Setup Role > Select SQL Server Feature Installation.

Install and Configure SQL Server Reporting Services - Setup Role

  • From Feature Selection > Below Instance Features
    • Select Database Engine Services.
    • Select Reporting Service -Native > Click Next.

Install and Configure SQL Server Reporting Services - Features

  • Configure instance by setting the instance name or leave default.

Install and Configure SQL Server Reporting Services - Instance Configuration

  • Check Disk Space Requirement > Next.

Install and Configure SQL Server Reporting Services - Disk Space

  • In Server Configuration > Set SSRS Service Account > Next.

Install and Configure SQL Server Reporting Services - Server Configuration

  • In Reporting Service Configuration > Check Install only.

Install and Configure SQL Server Reporting Services - SSRS Configuration

  • In Error Reporting > Click Next.

Install and Configure SQL Server Reporting Services - Error Reporting

  • Once the Installation Configuration Rules have been passed > Click Next.

Install and Configure SQL Server Reporting Services - Configuration Rules

  • In Ready to install > Click on Install.

Install and Configure SQL Server Reporting Services - Installation ready

  • Complete the installation wizard and click Finish.

Configure SQL Server Reporting Services SSRS

  • Open Reporting Service Configuration Manager.

Reporting Services Configuration Manager

  • Click Find and select the existing instance that has been selected to add SSRS feature > Click on Connect.

Configure SQL Server Reporting Services - Connect

  • The Report Server Status should be shown with the current report server status and basic information about report server.

Configure SQL Server Reporting Services - Report Server Status

  • Go to Service Account section to check the service account that has been set during the installation, you can also change the current service account through this section based on your requirement.

Reporting Service Configuration Manager - Service Account

  • Go to the Web Service URL section to configure the URL and port number for Report Service Web Service > Click On Apply to generate it.

Reporting Service Configuration Manager - Web Service URL

  • Got to Database section > Click on Change Database.

Reporting Service Configuration Manager - Database

  • Follow the Change Database wizard > Check Create a new report server database > Next.

Reporting Service Configuration Manager - Create a new report server Database

  • Select Authentication Type “SQL Server Account” > Set the Username and Password for the account that should have permission to connect to SQL server.

Reporting Service Configuration Manager - Database Server

  • Click on Test Connection > Next.

Reporting Service Configuration Manager - Test Connection

  • Type your Database Name or leave it as default > Next.

Reporting Service Configuration Manager - Database name

  • Again set the credential for the user that should have permission to access the Report Server Database.

Reporting Service Configuration Manager - Database Credentials

  • Review the Summary > Next.

Reporting Service Configuration Manager

  • Wait until the Report Server Database Configuration wizard complete > Click on Finish.

Report Server Database Configuration Wizard

  • The Database section should show the current Report Server Database.

Reporting Service Configuration Manager - Report Server Database

  • Go to Report Manager section to configure the URL that will be used to access Report Manager. > Click on Apply.

Reporting Service Configuration Manager - Report Manager URL

  • Try to navigate to the Report Manager URL to open Report Manager.

Open Report Manager in Reporting Service

Note: in case you got any permission issue to open report Manager, please check

  • Click on Report Builder to build your report.

ssrs report builder.gif

  • Click on Run.

ssrs-report-builder-1

ssrs-report-builder-2

  • Great, the report builder is ready now to create your first report.

ssrs-report-builder-3

  • Go now to Encryption Keys to take a backup of the symmetric key that used to encrypt sensitive data in the report server database like connection strings, credentials …etc.

Note: the symmetric key backup is very important especially in case of migrating or moving the report server installation to another server.

you can restore this symmetric key to be able to access the encrypted content.


See also
Advertisements

One thought on “Install and Configure SQL Server Reporting Service (SSRS)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s