SQL Server Reporting Services (SSRS) is a server based scalable and extensible platform for authoring, deploying, executing and managing reports based on a variety of data sources.

Configuring SSRS Report Server

Click on Microsoft SQL Server 2012 Program Folder from the Start Menu.

Capture 74

Click on the connect button.

Capture 75

Click on Service Account option in the Left pane, here you have the option for choosing a built-in account or windows domain user account to use the Report Server Service.

Capture 76

Click on the Web Service URL option – this URL will be used to host and access the report server. Give the report server a name in the Virtual Directory option. Then, click on the apply option and your URL will be converted into a hyperlink, as shown below

Capture 77

The option Database, is for the Report server database. It is used for Meta data of reports. Click Change Database button on right pane and another window will open. You may opt for either an existing database or create a new database, then click on next.

Capture 78

Now, enter the database server name which you want to connect to, and then click on next button.

Capture 79

Now, you have to enter a name for the Report Server Database that will be used for storing Meta Data for the Report Server. After selecting the appropriate options that you need, click on the Next button. The Report database will be created.

Interested in mastering SSRS Training? 

Learn more about SSRS Tutorial in this blog post.

Capture 80

You may check your Report server database in the SQL Server IDE, as shown below.

Capture 81

Now, you are almost done with all the needed basics for starting to your SSRS sever.

You can now access your SSRS Report server using the URL “http://localhost/Reports/Pages/Folder.aspx”. The following page will be displayed in your browser:

Capture 82

For indepth understanding click on