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.



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.



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



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.



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.





Step 6

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



Step 7

Create a new report database.



Step 8

Change the 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.





Step 10

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



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.



Step 12

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



Step 13

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



Finally

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

Here we can manage all the report related items.



Conclusion

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