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 suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

sql-reporting1.pngIn this article, I will elaborate How to install and configure SQL Server Reporting Service (SSRS) native mode.

Note: The mentioned steps is valid for SSRS 2008 / 2012 / 2014.

Steps:

Install SSRS (I considered you already have installed SQL Server if the SQL server is not installed 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.

ssrs-installation_1

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

ssrs-installation_2

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

ssrs-installation_3

  • Check Product Updates and click Next.

ssrs-installation_4

  • Again, Check Setup Support Rules and click Next.

ssrs-installation_5

  • From Installation Types > Check Perform a new installation.

perform-a-new-installation-sql-ssrs

  • From Setup Role > Select SQL Server Feature Installation.

set-up-role-sql-ssrs

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

reporting-service-feature

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

sql-instance-configuration1

  • Check Disk Space Requirement > Next.

sql-check-disk-space

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

sqlserver-configuration

  • In Reporting Service Configuration > Check Install only.

install-only-ssrs

  • In Error Reporting > Click Next.

error-reporting-ssrs

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

installation-configuration-rules-ssrs

  • In Ready to install > Click on Install.

ready-to-install-ssrs.gif

  • Complete the installation wizard and click Finish.

Configure 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.

reporting-services-configuration-manager-conection

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

reporting-services-configuration-manager-report-server-status

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

reporting-services-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-services-configuration-manager-web-service-url

  • Got to Database section > Click on Change Database.

reporting-services-configuration-manager-database

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

reporting-services-configuration-manager-database-configuration

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

reporting-services-configuration-manager-database-configuration-1

  • Click on Test Connection > Next.

reporting-services-configuration-manager-database-configuration-2

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

reporting-services-configuration-manager-database-configuration-3

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

reporting-services-configuration-manager-database-configuration-4

  • Review the Summary > Next.

reporting services configuration manager database configuration 5.gif

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

reporting services configuration manager database configuration 6.gif

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

reporting-services-configuration-manager-database-configuration-7

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

reporting-services-configuration-manager-report-manager-url

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

reporting-services-configuration-manager-report-manager-url-home

  • 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

Enjoy 🙂

See also

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s