SQL Server 2012 Reports Services Configuration

Introduction

Reporting Services is a server-based reporting platform and it provides various reporting functionalities for a variety of data sources.

A report server enables report authoring experiences, report rendering and report delivery experiences for a variety of data sources as well as extensible authentication and authorization schemes. It's a database that stores data sources, datasets, published reports and so on. The admin user has the privilege to manage the permissions, process the report request, subscriptions and so on.

Configuration procedure

Step 1

Start =>All Programs =>Microsoft SQL Server2012 =>Configuration Tools => Reporting Services Configuration Manager.

reporting service

Click on this (with Admin privileges).

Step 2

In this wizard select our server name and report server instance and click on the “Connect” button.

connect

Step 3

Here we can see the start button. (While clicking on this maybe you will get an error related to user permissions, if so then go to the next tab Service Account).

start

Step 4

This step is to configure the service account. We can use the built-in account “Local system”. But in the production environment use of the domain account is recommended.

Enter the account details and Apply.

service account

Step 5

Configure your reports URL and virtual directory name. Also we can configure the SSL certificates. Click on Advanced, here we have the options for add/edit host header and other details if you need them.

web service url

reports url

Step 6

In this wizard we have the option to create a new report database and change the user credentials.

database

Step 7

Create a new report database.

new report database

Step 8

Change the user credentials.

user credentials

Step 9

Configure the report manager URL. Click on Advanced, here we have the options for add/edit host header and other details if you need them.

reports manage url

advance multiple web site

Step 10

This step is for configuring the email setting. Enter the sender address and SMTP details here.

SMTP details

Step 11

This account enables the use of report data sources that do not require the credentials or to connect to remote servers that store external items used in reports.

execution account

Step 12

This is for backup of the encryption key for the recovery plan.

increption keys

Step 13

This page is to view information about a scale-out deployment. We have the option to add/remove the servers.

scale out deployment

Finally

http://localhost/Reports_SQLSVR/Pages/Folder.aspx

Here we can manage all the report related items.

reports related items

Conclusion

In this article we learned how to configure the SQL 2012 Reports Services Server.